How can i select a long string with sql?

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)

Asked:

on 11 Oct 2017

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!