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
5 个评论
Walter Roberson
2019-4-2
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
2019-4-2
Guy Laviolette
2019-4-2
Guillaume
2019-4-2
What is the actual query that causes this error?
Guy Laviolette
2019-4-3
回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Reporting and Database Access 的更多信息
2019-4-2
2019-4-3
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
