Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Error :- String or binary data would be truncated  RSS feed

 
rameshmca rk
Greenhorn
Posts: 17
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
I tried to execute insert query using String and integer variables I got
"String or binary data would be truncated" error I tried for many times .But I did not get the insertion of data.Give me an complete requested insert statement example.
 
Jan Cumps
Bartender
Posts: 2628
17
C++ Linux Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by rameshmca rk:
Hi,
I tried to execute insert query using String and integer variables I got
"String or binary data would be truncated" error I tried for many times .But I did not get the insertion of data.Give me an complete requested insert statement example.


This means that you are inserting data that does not fit in your table's column.

If your column name can hold 10 characters, and you try to insert 'rameshmca rk', you can get this error.

If you show us your table definition and the query you use to insert the data, we can help you finding out the exact cause.

Regards, Jan
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!