Re: Decimal separator in Oracle

Hi.
  I don't know if I can help you but I think your problem is an oracle parameter named : NLS_NUMERIC_CHARACTERS, which I think is session specific; it contains the separators for numeric values. You can also set it into registry:
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 - or whatever home you have - key: "NLS_NUMERIC_CHARACTERS = .," for example.

  Hope this helps,
    Iustin Amihaesei

gilels_at_mail.ru (curious) wrote in message news:<84b1a83c.0110300237.48a98cb2_at_posting.google.com>...
> Need a help, please.
>
> I have installed Oracle8i on Windows NT 4 (Service Pack 4) server and
> created a database on it with default settings (by default it was
> created with CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic character set).
> In this database I have created a table SCOTT.NAD with two fields:
> id10_0 -> NUMBER(10,0)
> id10_5 -> NUMBER(10,0) and filled with the following values:
>
> id10_0 id10_5
> --------------
> 0 0.5
> 1 1.5
> 2 2.5
>
> When I used SQL "SELECT * FROM SCOTT.NAD" in SQL+ on the server the
> results shown were the same as above.
>
> Then I go to Windows NT Workstation (Russian edition, Service Pack 4 -
> in Russian the default decimal separator is "," - comma) and use the
> same SQL statment in SQL+ the results are following:
>
> id10_0 id10_5
> --------------
> 0 0,5
> 1 1,5
> 2 2,5
>
> and this result doesn't depend on what is the value of decimal
> separator ("," - comma or ".' - point) which is set through Control
> Panel -> International Settings -> Numbers.
>
> This is very strange and doesn't allow to work with database through
> ODBC driver
> because it generates ORA-01722 error.
Received on Wed Oct 31 2001 - 14:12:05 CET