This week's book giveaway is in the Other Languages forum.
We're giving away four copies of Functional Reactive Programming and have Stephen Blackheath and Anthony Jones on-line!
See this thread for details.
Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error :- String or binary data would be truncated

 
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: 2602
13
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic