FreeTDS Development Group

[ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>]

> 
> 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)....
> 
TDS5.0 manual state that TDSNUMERIC may have 77 as precision (1-77)...

Perhaps they think at the future...

I tried code like this for test:

CREATE TABLE #tmp1 ( x NUMERIC(38,0) )
INSERT #tmp1 (x) VALUES ( 1234567890 )
SELECT * FROM #tmp1
DROP TABLE #tmp1

And ethereal to see the wire...

freddy77

=================================
"STRICTLY PERSONAL AND CONFIDENTIAL

This message may contain confidential and proprietary material for the sole
use of the intended recipient. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient please contact
the sender and delete all copies.
The contents of this message that do not relate to the official business of
our company shall be understood as neither given nor endorsed by it."

=================================