Modify the character set of the Oracle database (UTF8 → ZHS16GBK) and utf8zhs16gbk
Modify the character set of the Oracle database (UTF8 → ZHS16GBK)
1. C: \ Users \ Administrator> sqlplus/nolog
2. Log On As sysdba
SQL> conn sys/root as sysdba
3.
Client Character Set, oracle client Character SetThis part is supported by oracle globalization. For more information, see the documentation.First, let's talk about the database character set. When we use dbca to create a database, we will let you
Change Procedure: 1. log on to sqlplus as a sysdba user using the sysdba role: run the following command: sqlplus sys as sysdba
2. Enter the password to go to sqlplus: SQL> ---
3. type the following command line in sequence for execution:
Shutdown
Oracle client query tools sometimes fail to display the result of investigation in Chinese text, either garbled or question mark. PLSQL has this problem, which is caused by version, the old database is the same as the latest one, and the new
Run the following commands in sqlplus:
Connect system as sysdba; -- Be sure to log in as DBA; otherwise, an error will be reported belowShutdown immediate; -- this is to disable the session currently connected to the database. If a session is
Event environment:
The server a character set is inconsistent with the server B character set.
After the server a exp command exports the DMP file, garbled characters are displayed when IMP is imported into Chinese on server B.
Solution:
When installing the database instance, the system will select the country character set: Country: database character set. If the character sets of the two Oracle servers are different, it will be very troublesome during data migration.
View the
Server: (oracle Server Character Set) database character set specified during database creation. It cannot be changed after database creation. When creating a database, you can specify the CHARACTERSET and NATIONALCHARACTERSET ). 1. Character Set: (1
Modify the server character set (not recommended)
Before Oracle 8, you can directly modify the data dictionary table props $ to change the Oracle Character Set of the database. However, after oracle8, at least three system tables record the
Views and modifies the oracle character set, and explains how to view the oracle version.
1. view the database Character Set
Database Server Character Set select * from nls_database_parameters, which is derived from props $ and represents the
1. the NLS_LANG parameter is composed of the following parts: nls_lang?age_territory.clientscharactersetnls_lang each part has the following meanings: LANGUAGE specified: -Oracle message language-day in date month and day display TERRITORY
Q] how to view the database character set [A] database server Character Set select * fromnls_database_parameters, which comes from props $ and represents the database character set. Select * fromnls_instance_parameters from the client Character Set
Today, when I imported the previously backed up data to oracle, I found the prompt ORA-12899 error value too large for column, this is the problem of too big data, let me share the solution process with you.
The following error occurs when exporting
Because my operating system is in English, Chinese characters cannot be correctly displayed in some places when I start my project. At that time, it was suspected that it was a problem with the operating system, but later I found that all Chinese
L FAQs:
UCM-CFG-5137: Content Manager was unable to complete the initialization of
Content store.
Solution:
1. Ensure that all Cognos 8 Services are stopped.
2. Have the DBA make a backup the Content Store.
3. Have the DBA runInstall_path\
Modify the encoding of the data to UTF-8
View and modify Oracle encoding format Method-view Oracle database Character set:
Select Userenv (' language ') from dual;
Query results:
Simplified Chinese_china. Al32utf8
--Modifying the Oracle Database
Frequently, colleagues consult Oracle database character set issues, such as data migration in different databases, exchange of data with other systems, and so on, often because of different character sets that cause migration to fail or the data in
The Al32utf8 character set is not a (display/input) language character set, is a character set for storage and supports the world's leading language encoding.
Al32utf8 is a superset of ZHS16GBK.
The Nls_lang should be set to the language
Scenario: There is a database encoded as UTF8 on the server, and then the local is ZHS16GBK. I directly with the EXP command to guide down, found that the database is garbled.
Resolution process: Because the code on the server is not easy to change,
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.