FreeTDS Development Group

[Bob Kline <bkline AT rksystems.com>]

On Sun, 9 Jun 2002, Franck Martin wrote:

> Brian and others...
>
> The problem is always the same, if I redo the same query I have
> exactly the same strange behavior character by character...
>
> It seems indeed that it is related to non-null terminated strings.
> From the flow of data from the capture I see that the string is not
> terminated and only the pair of bytes before the string gives the
> length of the string (ie 0400 for AN or 1c00 for Annual Reports).

It appears that PHP is looking at the value which represents the number
of bytes in the data buffer, but is thinking that this value represents
the number of characters in the data buffer.  Notice, for example, that
the value for ReportType is always two characters, and PHP is always
pumping out four single-byte characters (because that's how many bytes
are present for two NVARCHAR characters).

-- 
Bob Kline
mailto:bkline AT rksystems.com
http://www.rksystems.com