Re: comma as decimal point in SQL statement

I did add this line to my init.ora file. It displayed comma as decimal point in results when I used SQLplus. However, it wouldn't take comma as decimal point in a sql statement in SQLplus. It also wouldn't take comma as decimal point in a sql string passing through ADO.

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.
>
> 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 - 19:08:22 CST