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

5 Ansichten (letzte 30 Tage)
Jacek Szkutnik
Jacek Szkutnik am 1 Jul. 2020
Kommentiert: Polsak Tothong am 23 Mär. 2024
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?

Melden Sie sich an, um diese Frage zu beantworten.

Akzeptierte Antwort

Jacek Szkutnik
Jacek Szkutnik am 6 Jul. 2020
Bearbeitet: Jacek Szkutnik am 6 Jul. 2020
'SQLSRV32.DLL' ODBC driver is able to retrieve whole data from NVARCHAR(MAX) fields.

Weitere Antworten (0)

Kategorien

Mehr zu Configure Environment finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by