Common character sets and solutions for Oracle character sets

Common character sets and solutions for Oracle character sets

One. View the character set:

1. Query the service-side character set:

Select Userenv (' language ') from dual

Or

SELECT * FROM Nls_database_parameters

2. Query the client:

SELECT * FROM Nls_instance_parameters

Problems such as garbled characters in the client character set and the service-side character set will occur

3. Session Character Set:

select * from Nls_session_parameters

Two. Modify the character set:

1. Modify the client Character set: (recommended)

Open registry: Cmd-regedit

Hkey_local_machine\software\oracle\key_oradb10g_home1 's Nls_lang

2. Modify the value of the Nls_lang to:

For example, the server is: simplified Chinese_china. Al32utf8 then the client can also modify it to

If the issue is still not resolved through the registry, modify the environment variable: Nls_lang

Server-side Character Set modification: (Discreet)

Three.

Common character sets and solutions for Oracle character sets