Oracle Modified character encoding

ALTER DATABASE Character set Internal_use ZHS16GBK;

ALTER DATABASE CHARACTER SET zhs16gbk;

Oracle Modify character encoding 1

1 Opening a Command Window 2

2 View current character encoding 3

3 Executing the command 4

Oracle Modified character encoding

1. Open a Command Window

Sqlplus Shybt/[email PROTECTED]:1521/ORCL

1. View current character encoding
   1. Select Userenv (' language ') from dual;

1. Execute command

1. Shutdown immediate;

1. Startup Mount
2. ALTER SYSTEM ENABLE RESTRICTED SESSION;
3. ALTER SYSTEM SET job_queue_processes=0;

1. ALTER SYSTEM SET job_queue_processes=0;

1. ALTER SYSTEM SET aq_tm_processes=0;
2. ALTER DATABASE open;

1. ALTER DATABASE character set internal_use Al32utf8;
2. Shutdown immediate
3. Startup

Successful execution

Oracle Modified character encoding