- Change the driver of the MATLAB 'Database toolbox' to JDBC driver, from ODBC driver.
- Change the datatype of the field ‘jsonfid’ in ‘SQL’ table from ‘NVARCHAR(MAX)’ to ‘TEXT’.
Incomplete large json string from SQL DB
조회 수: 17 (최근 30일)
이전 댓글 표시
Hi,
I have a large json string stored in SQL DB. table in SQL has 2 fields [ ID BIGINT, jsonFld NVARCHAR(MAX)]
If i used below command, I only get partial string back from SQL.
tSQL='SELECT ID, jsonFld FROM DBtable WHERE ID=1';
ttxt = connDB.fetch( tSQL);
If I used below, I can retrieve more text but still not complete.
tSQL='SELECT ID, jsonFld= CAST( jsonFld AS TEXT) FROM DBtable WHERE ID=1';
ttxt = connDB.fetch( tSQL); % The length( ttxt.jsonFld) is 9999999.
any suggestion on what I can do to receive full NVARCHAR(MAX) string back from SQL?
Thanks,
댓글 수: 0
답변 (1개)
Abhaya
2024년 8월 16일 6:31
Follow the steps given below, to retrieve full string of the field named ‘jsonfid’ with ‘NVARCHAR(MAX)’ datatype from a SQL db.
You can refer to the following MATLAB Answers community question for further explanation.
Hope this helps.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Database Toolbox에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!