Decimal point and decimal comma

From: Stefan Nobis <stefan_at_snobis.de>
Date: Fri, 16 Jul 2004 09:10:45 +0200
Message-ID: <87r7rcqvey.fsf@snobis.de>

Hi!

I have a problem with Oracle, decimal point/comma and a <censored> database admin. My application runs on a german Windows and first we had a german Oracle -- so everywhere the decimal comma is used.

Now we got an update to an english version of Oracle. So Oracle thinks the value 3,7 means 37 and Windows thinks that values like 3.7 means 37.

I use the Oracle ODBC driver and my application is written in VB6. Once i tried the Microsoft ODBC driver for Oracle -- it converted correct between decimal point/comma but it provides only ODBC level 2 but i need level 3 (which is provided by the Oracle ODBC driver).

Are there any ways to get the Oracle driver to convert correctly between decimal point/comma? Or has anyone any other suggestion to the problem? I'm very thankful for any hint!

-- 
Stefan.

Received on Fri Jul 16 2004 - 02:10:45 CDT