[Turn] The encoding of the Oracle database into Utf-8

1, change the client character set: run regedit from the Windows Run menu, modify the registry

Start, Run, Rededit <-|

Under registry Editor-> HKEY_LOCAL_MACHINE-Software->oracle->key_xe->right WINDOW DOUBLE CLICK Nls_la NG-and change-VALUE to "American_america. UTF8 "->ok->close REGISTRY

How to set up the Oracle client character set correctly:

The Oracle client character set settings need to be consistent with the server side, or garbled problems may occur.

First, connect to the server and query the server-side settings:

SELECT * from V$nls_parameters;

Found it:

Nls_language

Nls_territory

Nls_characterset

The environment variable Nls_lang is made up of these three parts

Nls_lang = Language_territory.charset

Like what:

Nls_lang = American_japan.ja16sjis

2, change the server-side character set , through the Oracle SQL Plus Command window

In Sql*plus, log on as DBA

Conn User name as Sysdba

Then execute the following command

>shutdown immediate; (the database was stopped)

>startup Mount; (Re-open the database to change the situation)

>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 UTF8;

OR

>alter database character set Internal_use UTF8; (This command is a cast encoding format that may cause the Chinese in the database to become garbled)

>shutdown immediate;

>startup; (Re-open normal Oracle)

Oracle Database Character Set modification complete!

The database server character Set select * from Nls_database_parameters, which is derived from props$, is the character set representing the database.

Client Character Set Environment select * from Nls_instance_parameters, which originates from V$parameter,

[Turn] The encoding of the Oracle database into Utf-8