"String or binary data would be truncated. The statement has been terminated." Please explain about this exception.

Question

1.00/5 (4 votes)

See more:

SQL-Server-2005

SQL-Server

"String or binary data would be truncated. The statement has been terminated." Please explain about this exception.

Posted 7-Dec-11 20:09pm

maajanes

Updated 5-Feb-20 21:26pm

Add a Solution

4 solutions

Solution 6

Hi,
Its the error because of data-type and what the size you are passing for inserting data to that field.Suppose i have declared a field named name varchar[20] and i am trying to inserting name of more than 20 characters then i will get an error like "String or binary data would be truncated". So please check all the field.Hope this will work.If not let me know about the error.

Posted 10-Mar-14 19:07pm

SanSkun

Comments

Member 14074976 16-Jun-19 22:18pm

Thank you sir now know that issue may error thanks dost

Member 14944961 17-Oct-20 7:54am

hi

Solution 4

when user store data at that time size of data type is less as compared to required data type size then it gives such kind of error solution to increase your data type size...

Posted 3-Mar-13 5:31am

marigold12

Comments

[no name] 3-Mar-13 11:50am

Exactly what the other solutions told him in Dec 2011. How does your solution in any way provide any additional information on this question?

bramh_dwivedi 28-Apr-13 13:37pm

how i can handle this exception String or binary data would be truncated.\r\nThe statement has been terminated."

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

uspatel · Accepted Answer · 2011-12-07T20:17:00

Solution 1

This exception occures when your datatype,size does not match with database field attributes.
See Discussion

Posted 7-Dec-11 20:17pm

uspatel

Comments

Mehdi Gholam 8-Dec-11 2:18am

5'ed

uspatel 8-Dec-11 2:30am

thanks..

James McCullough 1-May-16 2:27am

LOVE IT! Simple and to the point!

Member 12625053 22-Jul-16 2:56am

I have set my fields datatype as varBinary(MAX). it is uploading .txt file but giving exception to any other fileType

Member 13607841 5-Feb-18 7:05am

thanks

koolprasad2003 · Accepted Answer · 2011-12-07T20:31:00

Solution 2

String or binary data would be truncated Error suggests your Datatype in Database is smaller than inserted value.

1. Increase datatype length or decrease length of value before inseration.

Posted 7-Dec-11 20:31pm

koolprasad2003

Comments

kinjal b patel 11-Oct-12 8:42am

thanks buddy ..........!

Member 14788228 5-Apr-20 13:47pm

the size of the datatype is same as the attribute in the database. and i am inserting less datatype than i put in max size. and still i am facing on this error.