Thread:

>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

I ended up changing the data types to float8...
Why the warning against using float4?
Will I encounter problems using float8?

-asif.

JT Kirkpatrick wrote:

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