FreeTDS Development Group

["Bill Thompson" <thompbil AT exchange.uk.ml.com>]

Freddy,

> Coding of numeric (and decimal) in different TDS version is different. It
> seem that TDS 4.2 and 5.0 use always big endian conversion and TDS7/8 use
> always little endian. 
> Also MS SQL is limited to 38, Sybase to 77 (128 and 256 bit).
> So for Sybase a require data to be 33, not 17 (see tds.h.in).

The sybase manuals I've looked at (11.5 & 12) say numeric and decimal have
38 significant digits (2 to 17 bytes of storage)....

> Also we have a global g__numeric... (I don't remember exactly, an array)
> variable for calculate numeric length. This variable is initialized globally
> on connection. This cause two problem:
> - calling convert to/from numeric before connecting can cause big problem
> (core dump and other) and wrong conversion
> - a single process cannot connect to Sybase and SQL Server also
> 

Yup I guess you're right. I'll take a look at that.

Bill