FreeTDS Development Group

[Dave Zavasnik <drz AT cmg.fcnbd.com>@hell.cmg.FCNBD.COM AT hell.cmg.FCNBD.COM]

Mark Schaal wrote:
> 
> Craig Spannring already asked this back in October, but there didn't
> seem to be a response listed.  Could someone with a Sybase system
> check the value of the datatype marker for smallmoney?
> 
> "In the file tds.h SYBMONEY4 is defined as 112. SQLServer seems to be
>  returning 122 for the SMALLMONEY type. Did Sybase and SQLServer
>  diverge here, or is the constant wrong in tds.h?"
> 
> Thanks,
> 
> Mark
> --
> Mark J. Schaal                                  Phone:      (909) 620-7724
> TST On Ramp                                     Fax:        (909) 620-8174
> System Administrator                            E-Mail: mark AT tstonramp.com
> 
> ---
> You are currently subscribed to freetds as: drz AT cmg.fcnbd.com
> To unsubscribe, forward this message to $subst('Email.Unsub')

Mark,


Sybase Version 10 and 11 (on Solaris) :
 
s3000{drz}26: pwd
/usr/sybase/opencs11.1.1/include
s3000{drz}27: grep SYBMONEY4 *
sybdb.h:#define SYBMONEY4       (BYTE)0x7A


Dave