comma as decimal point in SQL statement

From: <mingoz_at_my-deja.com>
Date: Tue, 06 Feb 2001 01:37:12 GMT
Message-ID: <95nkg8$10$1@nnrp1.deja.com>

Due to the change of regional settings on my NT Server, my SQL statement for updating an Oracle database through ODBC looks like this: "Update table1 set item1 = 12,34, item2 = 23,45 where item3 > 1,1". As you can see, the decimal point is replaced by comma because of the western European regional settings. My Oracle database is installed on the same NT server where the regional setting is changed. I tried to change all the NLS_LANG setting in the registry. It did not work. I added NLS_LANGUAGE and NLS_NUMERIC_CHARACTERS to the ini file. They only change the display in SQL plus.

What do I have to do with Oracle server in order to run a sql statement like the one shown above?

Thanks,

Mingoz

Sent via Deja.com
http://www.deja.com/ Received on Mon Feb 05 2001 - 19:37:12 CST