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)