How can i select a long string with sql?
1 view (last 30 days)
Show older comments
Hello,
I have an mssql table with an nvarchar column. It contains 95 kbyte string data. When i run a select for the table, it does not return the value of the column.
I use this ODBC sql connection: conn = database('Name','User','Pass'); data = exec(conn, 'SELECT longDataColumn FROM Table'); d = fetch(data); value = d.Data; close(d); close(conn);
When i run the query it returns 'null' for the longDataColumn. If i select a name field with short string data content, it is successfully returned.
Could you please help me with this problem? Regards Gabor
0 Comments
Answers (0)
See Also
Categories
Find more on Structures in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!