Home > Database > Oracle > How to modify oracle database encoding

How to modify oracle database encoding

WBOY
Release: 2022-06-07 18:12:06
Original
5347 people have browsed it

Method: 1. After closing the database, use "startup mount;" to start the database in mount mode; 2. Use the "alter system set job_queue_processes=0;..." statement to enable strict mode; 3. Use "alter "database character set internal_use encoding" to modify the encoding; 4. Restart the database.

How to modify oracle database encoding

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to modify the oracle database encoding

Take ZHS16GBK -> AL32UTF8 as an example

1. Start the database first

If oracle If the service is running, there is no need to start it

startup;
Copy after login
Copy after login

Close the database

shutdown immediate;
Copy after login
Copy after login

Then start the database in mount mode

startup mount;
Copy after login

2. Enable strict mode

How to modify oracle database encoding

3. Encode

ALTER DATABASE CHARACTER SET AL32UTF8;
Copy after login

This may cause an error, prompting our character set: the new character set must be the old character set Superset, then we can skip the check of the superset and make changes:

ALTER DATABASE character set INTERNAL_USE AL32UTF8;
Copy after login

This statement is enough. The help provided by TERNAL_USE will allow Oracle to bypass the verification of the subset and superset. This The internal operation of this statement is exactly the same as that of the above statement.

4. Restart the database

Close the database

shutdown immediate;
Copy after login
Copy after login

Start the database

startup;
Copy after login
Copy after login

How to modify oracle database encoding

##Recommended Tutorial: "

Oracle Video Tutorial"

The above is the detailed content of How to modify oracle database encoding. For more information, please follow other related articles on the PHP Chinese website!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template