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