[freetds] Truncated String after Empty String

Mark Larsen larsenmtl at gmail.com
Mon May 21 15:08:15 EDT 2007


I can't believe the standard Gentoo ebuild is so out of date.
Thanks.



On 5/2/07, ZIGLIO, Frediano, VF-IT <Frediano.Ziglio at vodafone.com> wrote:
>
>
> > -----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
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



More information about the FreeTDS mailing list