Re: comma as decimal point in SQL statement

In article <95on12$lm1$1_at_news.inet.tele.dk>,   "Lehmann" <Spaceboy_NOoneSPAM_at_hotmail.com> wrote:
> Try to set NLS_NUMERIC_CHARACTERS in the init.ora file instead.

In addition to setting the NLS settings, make sure that the Windows client regional settings are such that the comma is the expected decimal point. While the Oracle ODBC driver uses the NLS settings exclusively, the application which is calling ODBC will often rely on the Windows settings. Discrepencies between the two settings often lead to headaches later on.

>
> 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/
>
>

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