Error while using sqlwrite - String data, right truncation

Hello, I am using the database toolbox, and I want to add a database to an already existing database on Microsoft SQL server.

However, I get this error:

Error using database.odbc.connection/sqlwrite (line 214)

ODBC JDBC/ODBC Error: ODBC Driver Error: [Microsoft][SQL Server Native Client 11.0]String data, right truncation.

Error in write2db (line 15)

sqlwrite(Conn, TableName, Table)

FYI, the number of columns are the same. I don't know if it is due to heavy strings or not.

Does someone have an idead?

Thanks a lot

[Walter Roberson]

I wonder if one of the fields you are trying to write is a string object or character vector (or, more likely, cell array of character vectors), and if the field was defined as a fixed width, and you are trying to write something wider than was allocated?

[Guy Laviolette]

Thank you. Well my objects are tables, and each day I am supposed to add a table in my database on SQL. Do you think it is a class issue?

[Guy Laviolette]

All of these tables have the same width.

[Guillaume]

What is the actual query that causes this error?

Also, see this article from Microsoft. Updating SQL server may fix the problem.

[Guy Laviolette]

Thank you for your answers. The problem wat that there was a longer string than the maximum length defined for a specific column.