Microsoft SQL中的错误“字符串或二进制数据将被截断”

Question

将数据插入到Microsoft SQL时出现此错误。

error: ('22001', '[22001] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]String or binary data would be truncated. (8152) (SQLParamData); [01000] [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated. (3621)')

仅供参考，我使用Python 2.7和pyodbc库。

这个错误是关于什么的？我该怎么解决呢？

Answer 1

基于此链接：http://www.sql-server-performance.com/2007/string-or-binary-data-truncated/

This error message appears when you try to insert a string with more characters than the column can maximal accommodate.