How can i select a long string with sql?

1 view (last 30 days)
Gabor Barta
Gabor Barta on 11 Oct 2017
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 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!