- Mailing list pgsql-interfaces

From JT Kirkpatrick
Subject
Date
Msg-id 01BEC3D4.AD2F64C0.jt-kirkpatrick@mpsllc.com
Whole thread Raw
List pgsql-interfaces
>Subject: bug: Access sees money types incorrectly

it's the odbc -- it doesn't recognize the money type.  i have had to use 
int4, storing all entries *100 (i.e. 35.99 as 3599), and then on reports be 
sure to divide by 100.  DON'T use float4!!  in postgres6.5 i understand the 
newer numeric type is available, but i don't know if the odbc can use it 
yet. . .

jt



pgsql-interfaces by date:

Previous
From: Philippe Chaintreuil
Date:
Subject: Re: [INTERFACES] Getting max. value size (libpq++)
Next
From: "Collin F. Lynch"
Date:
Subject: Time and microseconds?