Skip to Content.
Sympa Menu

freetds - Money -- always swapped

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: ZIGLIO Frediano <Frediano.Ziglio AT vodafoneomnitel.it>
  • To: "Freetds (E-mail)" <freetds AT franklin.metalab.unc.edu>
  • Subject: Money -- always swapped
  • Date: Fri, 30 Aug 2002 15:19:05 +0200


I tested convert_acid. Very useful program !!
It seem that mssql send money as a structure like

struct money {
int high;
unsigned low;
}

This result in a swapped uint64 type (with two 32bit part swapped, not all
bytes)
I tested with ethereal (packet sniffer) and sql query analizer and wire data
are just swapped !!
tds_money_to_string accept this coding, other not (see comments in
numeric.c).
I think this is the problem in money data...
How work sybase? From the strange result on ML and from numeric.c I think
the same way...

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."

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




Archive powered by MHonArc 2.6.24.

Top of Page