"Oracle" character set, national character set, and Nls_lang runtime

************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************   

--unicode Coding Scheme
--three standards of implementation: UTF-8,USC-2,UTF-16
--oracle Database Character Set
--Character Set character set
--national Character set character set
--Character Set main function
--For storing Varchar2,char,clob,long type data
-Name of the table, column name, and PL/SQL variables;
--Storage of SQL and Plsql code
--The national character set is used to store data types such as Nchar,nvarchar2,nclob;
--Generally for AL16UTF16
--the character set of the Simplified Chinese platform is generally zhs16gbk;
--Common Chinese code
--zhs16gbk231280 gbk2312-80 16bit,ascii
--ZHS16GBK GBK 16BIT,ASCII,UDC;
--GBK2312 was implemented in 1981,
--GBK 1995 implementation, support all Chinese and Japanese Han men
The encoding of--GBK and GBK2312 is different, the same encoding may express different kanji
--al beginning, such as Al16utf16,al said trial all reasons;
--nls Run-Library path: Oracle_home/nls/data
--Definition Language nls_language
--Define Area Nls_territory
--Define character set Nls_characterset
--Chinese file, LX00023.NLB, open through locale Builder
--conversion of characters and encodings
Select Dump (' cover ') from dual;
--------------
---typ=96 len=2:184.199
Select Concat (To_char (184, ' xx '), To_char (199, ' xx ')) from dual;
--B8 C7
Select To_number (' B8c7 ', ' xxxxxx ') from dual;
--47303
Select Chr (47303) from dual;
--Lid
Effects of--nls_lang
-When exporting an exp attack, it is very important that the client's character set settings, Nls_lang settings
--nls_lang=<language>_<territory>.<client characterset>
--LANGUAGE Specifies how the date is displayed, the language used by the Oracle message
The--territory parameter specifies the format of currency and numbers
--characterset controls the character set
--Import and export and character conversion
--Different character sets for the source and target databases
--When importing, setting the client Nls_lang equals the character set at the time of export, the conversion is sent in the target data of the insert data to other character sets;

************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************   



"Oracle" character set, national character set, and Nls_lang runtime