How can i select a long string with sql?
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
Answers (0)
Categories
Find more on Database Toolbox 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!