Oracle SQL Developer client encoding Oracle SQL Developer client encoding oracle oracle

Oracle SQL Developer client encoding


On the PC that PLSQL is installed, set the value of NLS_LANG registery entry equal to the PC's operation system locale (code page), equivalent value.

How to detect operating system language locale?
How to map OS locale to NLS_LANG value?

When using PLSQL the initial parameter of client-language that is required to create an Oracle session is read from NLS_LANG registry entry.

Due to Oracle documents, invalid data usually occurs in a database because the NLS_LANG parameter is not set properly on the client.The NLS_LANG value should reflect the client operating system code page.
For example, in an English Windows environment, the code page is WE8MSWIN1252. When the NLS_LANG parameter is set properly, the database can automatically convert incoming data from the client operating system to its encoding.

When using JAVA method, the client-language parameter is set by the value from the Control Panel, under Regional and Language Options, so the things will be OK.


You can try to change NLS_LANG value on your Win PC with regedit tool.

Path is: \HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE, when NLS_LANG contain value of your Oracle client's current encoding.

There is Oracle's list of available encodings:Commonly Used Values for NLS_LANG