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

6 vues (au cours des 30 derniers jours)
Jacek Szkutnik
Jacek Szkutnik le 1 Juil 2020
Commenté : Polsak Tothong le 23 Mar 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?

Connectez-vous pour répondre à cette question.

Réponse acceptée

Jacek Szkutnik
Jacek Szkutnik le 6 Juil 2020
Modifié(e) : Jacek Szkutnik le 6 Juil 2020
'SQLSRV32.DLL' ODBC driver is able to retrieve whole data from NVARCHAR(MAX) fields.

Plus de réponses (0)

Catégories

En savoir plus sur Configure Environment dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by