FreeTDS Development Group

[Mark Schaal <mark AT champ.tstonramp.com>]

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