[freetds] String or binary data would be truncated

Robert Dobbs bobisdobbs at hotmail.com
Tue Sep 19 20:47:38 EDT 2006

>From: "Nguyen, Thi X." <tnguyen at powertv.com>
>Date: Tue, 19 Sep 2006 17:41:30 -0700
> >From a Linux box, I am able to do the $hDatabase->do("UPDATE .....
>but the 	$hStatement->execute() gives me error
>DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server] String or
>binary data would be truncated. (SQL-22001)
>and the script quits.

It means the input exceeds the maximum length of the field definition, i.e. 
the field is VARCHAR(50) but your input is 52 characters.


All-in-one security and maintenance for your PC.  Get a free 90-day trial!  

More information about the FreeTDS mailing list