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: "Nguyen, Thi X." <tnguyen AT powertv.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] String or binary data would be truncated
  • Date: Tue, 19 Sep 2006 18:08:20 -0700

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.

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


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





Archive powered by MHonArc 2.6.24.

Top of Page