Incomplete large json string from SQL DB

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,

Answer 1

[Abhaya]

Follow the steps given below, to retrieve full string of the field named ‘jsonfid’ with ‘NVARCHAR(MAX)’ datatype from a SQL db.

• 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’.

You can refer to the following MATLAB Answers community question for further explanation.

https://www.mathworks.com/matlabcentral/answers/587489-sql-select-not-returning-full-string-from-query

Hope this helps.