How can i select a long string with sql?
Ältere Kommentare anzeigen
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
Antworten (0)
Kategorien
Mehr zu Database Toolbox finden Sie in Hilfe-Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!