Change the way the ODBC driver returns 'money'

From: "Mathew Frank" <mfrank(at)bigpond(dot)net(dot)au>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: Change the way the ODBC driver returns 'money'
Date: 2001-08-07 10:19:06
Message-ID: HHEBIKEIGDLFABEKDCCKCEKMCGAA.mfrank@bigpond.net.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

Browse pgsql-odbc by date

  From Date Subject
Next Message Marc G. Fournier 2001-08-07 13:54:49 Re: To be 7.1.3 or not to be 7.1.3?
Previous Message Justin Clift 2001-08-07 04:03:44 To be 7.1.3 or not to be 7.1.3?