update query with Freetds

Roger Burton West roger at firedrake.org
Wed Sep 6 09:45:11 EDT 2000


On or about Thu, Sep 07, 2000 at 12:32:52AM +1100, Jai Cornes typed:

>*nodnod*  Seen it, sweated over it, stuck it on a TODO list for my 
>Copious Free Time (tm) . Our theory is that the MS SQL server uses \0,
>or NULs to mark the end of a string in a fixed length field. 
>We fixed it last week by having the Perl code trap them (they came out 
>as ^@) with a regex, and delete them.

Yup; I'm doing @array=map{s/\000//og;$_} $sth->fetchrow_array, or
close equivalents.

>And while we're on the DBD::Sybase topic, is it true there's now a 
>DBD:FreeTDS?

Yes, but not updated since 1999-01-27. I haven't tried it. Since
it appears that placeholders aren't implemented, I can't see it
giving any great advantage over DBD::Sybase.

Roger



More information about the FreeTDS mailing list