Postgres Pro
Downloads
Home   >   mailing lists

Change the way the ODBC driver returns 'money' - Mailing list pgsql-odbc

From Mathew Frank
Subject Change the way the ODBC driver returns 'money'
Date
Msg-id HHEBIKEIGDLFABEKDCCKCEKMCGAA.mfrank@bigpond.net.au
Whole thread Raw
List pgsql-odbc
Tree view 
I'm using Crystal Reports (4.6) and any money types come out on the reports
as '0.00'.  This is due to the ODBC driver returning money types in the form
'$9.99' when Crystal is expecing a format of '9.99'.

When using MS-SQL ODBC there is an option to turn off 'localised settings'
(or similar) which you check off to get around this problem.

Is there a way I can do this with pg-ODBC?

Regards,
Mathew

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: PostgreSQL with Centura Team Developer
Next
From: "Alex Rhomberg"
Date:
Subject: Re: Retrieving oid's