NLS Options and problem with decimal in PL/SQL Developer 14

[Kusio]

I switch from PL/SQL Developer 13 x32 to version 14.0.1.1965 (64 bit) and I notice some problem with conversion text to number. Simple example:

select
to_number('123.45')
from
dual
;

work fine, but when i changed "." to "," and switched settings

User Interface --> NLS Options

then it fail with conversion error. It looks like this settings isn't use or is overwrite by something else.

 

[Marco Kalter]

These settings are for the client only. They control how numbers are displayed, but not how the server session converts between text and numbers. You will need to change the NLS_LANG or NLS_NUMERIC_CHARACTERS of your Oracle Client to control the server session format.

 

[Kusio]

I chaged my NLS_LANG in registry. It exactly this same like I had on old laptop.

When i check NLS_NUMERIC_CHARACTERS on new one i get ".,"

On old one i have ", "

So where could be problem? It is problem with PL SQL x64 or with somethig else?

 

[Kusio]

Problem solved. This was Windows 10 faul. In "Advanced system settings" -> "Environment Variables" was created extra variable "NLS_NUMERIC_CHARACTERS" and decimal settings was taken from it. Not from national settings or NLS from registry.

Resolution: change it or delete.