Select * The From V$nls_parameter will show the values of Nls_characterset and Nls_nchar_charactersetThe methods for modifying character set Nls_characterset and Nls_nchar_characterset values are as follows:1, modify Nls_characterset:sqlplus "/As
Problems encountered during testing: Imp-00019:row rejected due to ORACLE error 12899
Imp-00003:oracle error 12899 encountered ora-12899:value too for column
Character Set problem: Source Library 192.168.216.172 is Oracle 9.2.0.6 ZHS16BGK, Chinese
Work required, installing Oracle 11g, an error occurred while importing backup data on another machine:
IMP-00019: Line denied due to ORACLE error 12899IMP-00003: ORACLE Error 12899 encounteredORA-12899: Column "ZHENG". D_dic "." Dicexplain value is
First, Sqlplus/nolog
Second, Conn Scott/tiger as SYSDBA (login administrator to create user)
Create user a identified by A; (Creates a username: a password: A. User and password can be defined by themselves)
Four, grant create session,create
--View Oracle database Character set:
SELECT * FROM V$nls_parameters
Select Userenv (' language ') from dual;
Query results:
Simplified Chinese_china. Al32utf8
--Modifying the Oracle Database Character set: (In SQL Plus)
Sql> Conn/as
Installing oracle11g on Centos6.4 does not set the character set, using the operating system default character set: we8mswin1252, which modifies the character set to: Al32utf8.
Sql> Select Userenv (' language ') from dual;
Simplified Chinese_china.
Problem:
VARCHAR2 (4000) ABC;
Intert into table_name (ABC) VALUES (' Here are 1500 characters ... ');
Error: Insert character too long. After testing, found that a Chinese character accounted for 3 bytes, it will be an error.
The crux of the problem:
Linux use service mysql restart command to restart MySQL service
The new database will use this character set as the default character set
Modify the character set of each database in the MySQL server
If there is a database before setting the
1. View database Character Set
The database server character Set select * from Nls_database_parameters, which originates from props$, is the character set representing the database.Client Character Set Environment select * from
What is an Oracle character setAn Oracle character set is a collection of symbols that are interpreted by a byte of data, having a size and a mutual containment relationship.Oracle's support for the national language architecture allows you to use
Before doing a system, encountered a problem! Today, I accidentally found the solution to this problem and posted it!!!
Problem Description:
VARCHAR2 (4000) ABC;
Intert into table_name (ABC) VALUES (' Here are 1500 characters ... ');
Error:
Select Userenv (' language ') from dual;--Modify the Oracle database character set to ZHS16GBK:Sql>conn/as Sysdba;Sql>shutdown immediate;Sql>startup Mount;Sql>alter system enable restricted session;Sql>alter system set
First, installation1. Go to Oracle's official website to download the XE version of the installation package [download path] (Oracle Database Express Edition 2 for Windows x64), unzip.
2. Double-click Setup.exe to
--The vast majority of dba/all/user/v_$/gv_$/session/index begins with a view--dba_tables means all the relational tables that the DBA has or can access. --All_tables All relational tables that a user has or can access. -User_tables means all the
(Transferred from Http://blog.chinaunix.net/uid-186064-id-2823338.html)Oracle in Imp Import Data Chinese garbled problemAfter importing data into Oracle with the IMP command, all of the queried text fields are garbled.
In principle, do not
How to change the Oracle character set to avoid garbled charactersTurn the notes of a great God.The most commonly used Oracle character set ZHS16GBK (GBK 16-bit Simplified Chinese) in the country supports traditional Chinese and stores a Chinese
Oracle Character Set1, IntroductionORACLE The database character set, which is Oracle globalization support (globalization), or national language Support (NLS), is used to store, process, and retrieve data in its native language and format. With
1.2 MySQL database character set knowledge1.2.1 MySQL database Character Set introductionSimply put, a set of text symbols and their encoding and comparison rules.The MySQL database character set includes two concepts: Character set (CHARACTER) and
When using PL/SQL developer, the query out of the text field is garbled, because the database number format and PL/SQL Developer encoding format is not uniform caused.I. Viewing and modifying the Oracle database character setSelect Userenv ('
" This article declined to reprint Original from http://990487026.blog.51cto.com"Thought:1, set the Linux character set to UTF8 encoding2, set the Oracle character set to UTF8 encoding3, set the Sqlplus client environment to UTF8 encoding4. If you
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.