[Oracle] Character Set, National Character Set, and NLS_LANG Runtime Library, using lenls_lang

Source: Internet
Author: User

[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

Related Article

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.