Error 'String or binary data would be truncated' in Microsoft SQL

Question

I got this error when inserting data to 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)')

FYI, I use Python 2.7 and pyodbc library.

What is that error about? What should I do to solve it?

Updated. If you can, please undo the downvote since I already update it. Thanks — Aminah Nuraini
– Aminah Nuraini, Commented Aug 29, 2016 at 7:24
The error message says it all, you try to copy data too big to fit the target, so the data gets truncated. Now you have to find the failing assignment, and adjust it somehow. — jarlh
– jarlh, Commented Aug 29, 2016 at 7:26
Possible duplicate of SQLException : String or binary data would be truncated — Matthias Burger
– Matthias Burger, Commented Aug 29, 2016 at 7:35

Aminah Nuraini · Accepted Answer · 2016-08-29 07:21:05Z

27

Based on this link: 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.

answered Aug 29, 2016 at 7:21

Aminah Nuraini

19.4k9 gold badges98 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Aminah Nuraini Over a year ago

I've quoted the essence. I just refer the link to honor the original author

Unnikrishnan R · Accepted Answer · 2016-08-29 07:38:43Z

2

figure out the issue using following step. in your insert satement ,use 'LEN' function to find the length of the input columns.

suppose you are selecting data from a temp table for input. use the below query to find out maximum size of that column and compare with the actual size of the column in your original table (table you are going to insert data).

    SELECT MAX(LEN(column1))
    FROM #yourInputData

edited Aug 29, 2016 at 7:38

answered Aug 29, 2016 at 7:28

Unnikrishnan R

5,0511 gold badge15 silver badges21 bronze badges

Collectives™ on Stack Overflow

Error 'String or binary data would be truncated' in Microsoft SQL

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related