FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

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