[freetds] String or binary data would be truncated

Nguyen, Thi X. tnguyen at powertv.com
Tue Sep 19 21:08:20 EDT 2006

 Thanks for the quick response Mark. However, the same script has been working from a windows box, except that the DBD::ODBC module used is of Windows version.

-----Original Message-----
From: Robert Dobbs [mailto:bobisdobbs at hotmail.com] 
Sent: Tuesday, September 19, 2006 5:48 PM
To: freetds at lists.ibiblio.org
Cc: Nguyen, Thi X.
Subject: RE: [freetds] String or binary data would be truncated

>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!  

     - - - - - Appended by Scientific Atlanta, a Cisco company - - - - - 
This e-mail and any attachments may contain information which is confidential, proprietary, privileged or otherwise protected by law. The information is solely intended for the named addressee (or a person responsible for delivering it to the addressee). If you are not the intended recipient of this message, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this e-mail in error, please notify the sender immediately by return e-mail and delete it from your computer.

More information about the FreeTDS mailing list