update query with Freetds
Mark Schaal
mark at champ.tstonramp.com
Wed Sep 6 14:29:13 EDT 2000
>
> >*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.
Yes, our MS SQL here returns a string 'dog' as a length 4 string 'dog\000'.
Don't know if Sybase is the same. I haven't reviewed the issue, but
it might be a lose/lose situation because some client programs
expect strings to be null terminated.
>
> Yup; I'm doing @array=map{s/\000//og;$_} $sth->fetchrow_array, or
> close equivalents.
For what it's worth, I've heard tr/\000//d is faster.
Mark
--
Mark J. Schaal Phone: (909) 620-7724
TST On Ramp Fax: (909) 620-8174
System Administrator E-Mail: mark at tstonramp.com
More information about the FreeTDS
mailing list