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

조회 수: 4 (최근 30일)
Jacek Szkutnik
Jacek Szkutnik 2020년 7월 1일
댓글: Polsak Tothong 2024년 3월 23일
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?

이 질문에 답변하려면 로그인하십시오.

채택된 답변

Jacek Szkutnik
Jacek Szkutnik 2020년 7월 6일
편집: Jacek Szkutnik 2020년 7월 6일
'SQLSRV32.DLL' ODBC driver is able to retrieve whole data from NVARCHAR(MAX) fields.

추가 답변 (0개)

카테고리

Help Center 및 File Exchange에서 Configure Environment에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by