A lot of people must be like me. Due to work needs, the development environment needs to be foreign language
Next, I'll talk to you about my handling of Oracle garbled.
My Windows environment is the processing order of Japanese
1. Modifying environment variables
The Nls_lang is set to Japanse_japan. Ja16jis
2. Modify the Registration Form
Run->regedit->Hkey_local_machine\software\oracle\homexx\nls_lang set to Japanse_japan. Ja16jis
3. Modifying the character Set
Processing in Sqlplus
>shutdown immediate;
>startup Mount;
>alter SESSION SET sql_trace=true;
>alter SYSTEM ENABLE RESTRICTED SESSION;
>alter SYSTEM SET job_queue_processes=0;
>alter SYSTEM SET aq_tm_processes=0;
>alter DATABASE OPEN;
>alter database character Set Al32utf8;
If the error ORA-12712 >alter DATABASE character set Internal_use Al32utf8;
Finally, to close the restricted mode >alter SYSTEM DISABLE RESTRICTED SESSION;
This Al32utf8 is compatible with Japanese, ja16jis or ja16jistiled can be
Japanese Windows system Oracle database garbled processing