[Oracle] Character Set, National Character Set, and NLS_LANG Runtime Library, using lenls_lang
**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**************************************** ********************************
-- Unicode encoding scheme
-- Three implementation standards: UTF-8, usc-2, UTF-16
-- Oracle Database Character Set
-- Character set
-- National character set
-- Character Set main function
-- Used to store varchar2, char, clob, and long data
-- Indicates the table name, column name, and pl/SQL variables;
-- Store SQL and plsql code
-- The national character set is used to store data types such as nchar, nvarchar2, and nclob;
-- Generally AL16UTF16
-- The character set of the simplified Chinese platform is generally ZHS16GBK;
-- Common Chinese Encoding
-- ZHS16GBK231280 GBK2312-80 16bit, ASCII
-- ZHS16GBK GBK 16bit, ASCII, UDC;
-- GBK2312 was implemented on December 12, 1981,
-- Implemented by GBK in 1995, supporting all Chinese, Japanese, and Japanese
-- The encoding of GBK and GBK2312 is different. The same encoding may express different Chinese characters.
-- AL, for example, AL16UTF16, which indicates all reasons for trial;
-- NLS Runtime library path: ORACLE_HOME/nls/data
-- Definition Language NLS_LANGUAGE
-- Define the region NLS_TERRITORY
-- Define the character set NLS_CHARACTERSET
-- Chinese file, lx00023.nlb, opened through locale Builder
-- Character and encoding conversion
Select dump ('gai') 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 (0, 47303) from dual;
-- Cover
-- Influence of NLS_LANG
-- When exporting exp attacks, it is very important to set the character set of the client and set the NLS_LANG.
-- NLS_LANG = <language >_< Territory>. <client characterset>
-- Language specifies the date display mode, which is the language used for oracle messages.
The -- territory parameter specifies the format of the currency and number.
-- Characterset controls the character set
-- Import and Export and character conversion
-- The character set of the source database and target database is different.
-- Set the client NLS_LANG to the character set at the time of export during import, and convert and send the insert data to the target data of other character sets;
**************************************** ********************************* *** Original article: blog.csdn.net/clark_xu Xu changliang's column**************************************** ********************************
Zookeeper