Re: comma as decimal point in SQL statement

From: Alex Filonov <afilonov_at_pro-ns.net>
Date: Tue, 06 Feb 2001 15:25:58 GMT
Message-ID: <95p51s$6od$1@nnrp1.deja.com>

You need to set NLS_NUMERIC_CHARACTERS in the registry. init.ora sets everything for the server, for client you need to change registry.

In article <95nkg8$10$1_at_nnrp1.deja.com>, mingoz_at_my-deja.com wrote:
> 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/
>

Sent via Deja.com
http://www.deja.com/ Received on Tue Feb 06 2001 - 09:25:58 CST