Skip to Content.
Sympa Menu

freetds - Re: update query with Freetds

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Mark Schaal <mark AT champ.tstonramp.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: update query with Freetds
  • Date: Wed, 6 Sep 2000 11:29:13 -0700 (PDT)


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




Archive powered by MHonArc 2.6.24.

Top of Page