[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.

Mark

_________________________________________________________________
All-in-one security and maintenance for your PC.  Get a free 90-day trial!  
http://clk.atdmt.com/MSN/go/msnnkwlo0050000001msn/direct/01/?href=http://www.windowsonecare.com/?sc_cid=msn_hotmail




More information about the FreeTDS mailing list