update query with Freetds

Tom Samplonius tom at sdf.com
Sat Sep 9 18:37:05 EDT 2000



On Wed, 6 Sep 2000, Mark Schaal wrote:

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

  It is a bug.  FreeTDS 0.47 never had this problem.  The problem appeared
somewhere around FreeTDS 0.50 and has supposedly been fixed in the CVS
code.  I'm using 0.47 until a new release is finally made.

Tom




More information about the FreeTDS mailing list