Skip to Content.
Sympa Menu

freetds - Re: Numeric

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Bill Thompson" <thompbil AT exchange.uk.ml.com>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: Re: Numeric
  • Date: Thu, 18 Jul 2002 05:10:16 -0400


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




Archive powered by MHonArc 2.6.24.

Top of Page