freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] String or binary data would be truncated
- 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
-
[freetds] String or binary data would be truncated,
Nguyen, Thi X., 09/19/2006
-
Re: [freetds] String or binary data would be truncated,
Robert Dobbs, 09/19/2006
-
Re: [freetds] String or binary data would be truncated,
Nguyen, Thi X., 09/19/2006
- Re: [freetds] String or binary data would be truncated, Robert Dobbs, 09/20/2006
-
Re: [freetds] String or binary data would be truncated,
Nguyen, Thi X., 09/19/2006
-
Re: [freetds] String or binary data would be truncated,
Robert Dobbs, 09/19/2006
Archive powered by MHonArc 2.6.24.