only 8000 character retrieved from SQL Server VARCHAR(MAX) column.

Hello, I am trying to write and read character data to SQL Server VARCHAR(MAX) column, and while writing to the database works fine I can get only the first 8000 characters from each row (I can get multiple rows so probably the amount of data is not the problem).

I am using an ODBC driver to SQL Server version 2014, Matlab version 2018a if that is important.

As I understand there is a problem with the ODBC driver.

Is there any version of ODBC driver that solves it?

Answer 1

[Jacek Szkutnik]

'SQLSRV32.DLL' ODBC driver is able to retrieve whole data from NVARCHAR(MAX) fields.

[Polsak Tothong]

How to set that up?