[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

[Macromedia][SQLServer JDBC Driver][SQLServer]String or binary data would be truncated.

Sometimes we got an error message like above while working ColdFusion(9) with MS SQL(2008) date base.  Then  what is the cause of the error??

Do not think much, just look you are entering value to some fields in the database with beyond the limit mentioned in the database.

e.g - You may have mentioned a field in database vcSearchField(VARCHAR(100)), but during any insert or update operation you are providing it to string of length more than 100.


Hope it will save your time. :)