Oracle UTF8 Character set goto GBK (RPM)

Source: Internet
Author: User
Tags goto

Recently, when a colleague deploys the system outside, the UTF-8 encoding format may be selected when the database is installed, and when the INSERT statement is imported, a Chinese character is considered to be three bytes, which is not possible.

Combined with the Internet search data, the Oracle database encoding format, from Utf-8 to GBK, everything is normal.

Attached: Plsql execution Record:

---------------------------

Microsoft Windows [version 6.0.6002]
Copyright (C) 2006 Microsoft Corporation. All rights reserved.

C:\users\administrator>sqlplus/nolog

Sql*plus:release 11.2.0.1.0 Production on Monday September 3 11:39:04 2012

Copyright (c) 1982, Oracle. All rights reserved.

Sql> Conn/as SYSDBA
is connected.
Sql> SHUTDOWN IMMEDIATE
The database is closed.
The database has been uninstalled.
The ORACLE routine has been closed.
sql> startup Mount;
The ORACLE routine has been started.

Total System Global area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 377488808 bytes
Database buffers 394264576 bytes
Redo buffers 5259264 bytes
The database is loaded.
sql> ALTER SYSTEM ENABLE RESTRICTED SESSION;

The system has changed.

sql> ALTER SYSTEM SET job_queue_processes=0;

The system has changed.

sql> ALTER SYSTEM SET aq_tm_processes=0;

The system has changed.

sql> ALTER DATABASE OPEN;

The database has changed.


Sql> ALTER DATABASE character set Internal_use ZHS16GBK;

The database has changed.

sql> shutdown immediate;
The database is closed.
The database has been uninstalled.
The ORACLE routine has been closed.
Sql> Startup
The ORACLE routine has been started.

Total System Global area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 377488808 bytes
Database buffers 394264576 bytes
Redo buffers 5259264 bytes
The database is loaded.
The database is already open.
Sql>

---------------------------

To view the encoding format:

Select Userenv (' language ') from dual;
SELECT * FROM Nls_database_parameters

Oracle UTF8 Character set goto GBK (RPM)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.