Skip to Content.
Sympa Menu

freetds - Re: [freetds] String or binary data would be truncated

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Robert Dobbs" <bobisdobbs AT hotmail.com>
  • To: freetds AT lists.ibiblio.org
  • Cc: tnguyen AT powertv.com
  • Subject: Re: [freetds] String or binary data would be truncated
  • Date: Tue, 19 Sep 2006 17:47:38 -0700


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





Archive powered by MHonArc 2.6.24.

Top of Page