Re: Decimal separator in Oracle

Hi
  I don't know why inserting this key in the registry didn't work for u, as I've used it and it worked fine. Anyway, I don't know where it's documented, if it's documented, as somebody told me this too. The reference is in Oracle documentation : Oracle reference. They say it's session specific so u can set it with alter session ( this wasn't a solution for me so I've used the registry key ). Btw, this registry setting is per client ( on the client system - not on server ) as it affects only the session loged in from that client.

The form is: NLS_NUMERIC_CHARACTERS =
"<decimal_character><group_separator>"

I'm sorry I realy don't know anything more about this settings. It seemed to me that all session parameters could be set into registry so u don't have to alter it with alter session.   Hope you'll solve it,
    Iustin Amihaesei

gilels_at_mail.ru (curious) wrote in message news:<84b1a83c.0111010111.7563be96_at_posting.google.com>...
> aiustin_at_thinvest.ro (Iustin Amihaesei) wrote in message news:<c0f47435.0110310512.4e72f244@posting.google.com>...
> >
> > 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
>
> Thanks for help.
>
> Inserting NLS_NUMERIC_CHARACTERS into registry had no effect -
> decimal separator stayed ",". I have looked in Oracle documentation
> and this registry key is not mentioned. So are sure this registry key
> is used and where I can read about it?
> I have changed NLS_LANG from RUSSIAN_CIS.CL8MSWIN1251 to
> AMERICAN_AMERICA.US7ASCII and that solved the problem - decimal
> separator became "." but of course character strings are not cyrilic
> so this is not a solution.
Received on Fri Nov 02 2001 - 12:42:03 CET