Skip to Content.
Sympa Menu

freetds - Re: [freetds] Truncated String after Empty String

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Truncated String after Empty String
  • Date: Wed, 2 May 2007 16:43:41 +0200



> -----Original Message-----
> From: freetds-bounces AT lists.ibiblio.org
> [mailto:freetds-bounces AT lists.ibiblio.org] On Behalf Of Mark Larsen
> Sent: giovedì 26 aprile 2007 20.06
> To: FreeTDS Development Group
> Subject: [freetds] Truncated String after Empty String
>
> List Members,
>
> Before I really start to dig into this, I'm curious if anyone has seen
> similar problems.
>
> I'm using a stack of unixODBC, freeTDS, perl, DBD:ODBC, DBI. I'm
> doing a perl DBI prepare /execute combo to conduct an insert. The
> first array I pass to execute has an empty string for a field, the
> second has the value 'PreCheck'. When I view the data in the database
> the 'PreCheck' has been truncated to 'P'. I've debugged my perl code
> and I can't find fault with it.
>
> Curious enough if I replace the empty string with ' ', it works as
> expected. Also if I replace the empty string with undef (the database
> takes this as a NULL) and things work as expected.
>
> Has anyone seen anything like this before?
>
> FreeTDS 0.62.3

^^^^^ this is the problem

> unixODBC 2.2.11-r1
> perl 5.8.8
> DBI 1.54
> DBD::ODBC 1.13
>
> Thanks,
>
> LarsenMTL

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page