Board index » delphi » What causes 'String or binary data would be truncated" error?

What causes 'String or binary data would be truncated" error?


2004-06-23 10:19:13 PM
delphi54
Anyone seen this error before? Do you know what causes it?
******ADO Errors*******
*Error Number: -2147217833 *
*Source: Microsoft OLE DB Provider for SQL Server
*Description: String or binary data would be truncated.
*Native Error: 8152
***********************
Thanks,
Bill N
 
 

Re:What causes 'String or binary data would be truncated" error?

Bill,
It's usually when you have varchar field (ex. defined as Varchar(5)) and
the data (a string) is longer than what will fit.
Good luck,
krf
"Bill N" <XXXX@XXXXX.COM>writes
Quote
Anyone seen this error before? Do you know what causes it?

******ADO Errors*******

*Error Number: -2147217833 *

*Source: Microsoft OLE DB Provider for SQL Server

*Description: String or binary data would be truncated.

*Native Error: 8152

***********************

Thanks,

Bill N