Re: Decimal separator in Oracle

aiustin_at_thinvest.ro (Iustin Amihaesei) wrote in message news:<c0f47435.0110310512.4e72f244_at_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 Thu Nov 01 2001 - 10:11:31 CET