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

10 次查看（过去 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 中查找有关 Database Toolbox 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by