Re: comma as decimal point in SQL statement

Try to set NLS_NUMERIC_CHARACTERS in the init.ora file instead.

Cheers
/Lehmann
<mingoz_at_my-deja.com> wrote in message news:95nkg8$10$1_at_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 Tue Feb 06 2001 - 05:25:14 CST