View and modify Oracle Server Character Set

View and modify the character set on the Oracle server:

Method 1:

1) view the server character set:

Select * from V $ nls_parameters;

Select * From nls_database_parameters;

Select * From SYS. Props $;

2) modify the server character set (sys user ):

First Run: Update props $ set value $ = 'we8iso8859p1 'Where name = 'nls _ characterset ';

Update props $ set value $ = 'China' where name = 'nls _ language ';

Commit (COMMIT), and then restart the database;

3) Use a client tool (PL/SQL develop or Pb etc .) query the database. If garbled characters are displayed, first query the character set of the database, and then modify the value of the nls_lang field from the Registry, which may be american_america.we8iso8859p1 or simplified chinese_china.zhs16gbk or Na.

Method 2:

Alter system enable restricted session;

Alter database orcl Character Set zhs16gbk;

Alter database orcl National Character Set zhs16gbk;