Full description of Oracle Character Set

Source: Internet
Author: User

Oracle Character Set problems are often encountered when learning Oracle. Here we will introduce solutions to Oracle Character Set problems. The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. Oracle supports the national language architecture, allowing you to store, process, and retrieve data in a localized language. It makes database tools, error messages, sorting order, date, time, currency, numbers, and calendar automatically adapt to localization languages and platforms.

 
 
  1. SELECT * FROM V$NLS_PARAMETERS  
  2. NLS_LANGUAGE SIMPLIFIED CHINESE  
  3. NLS_TERRITORY        CHINA  
  4. NLS_CURRENCY RMB  
  5. NLS_ISO_CURRENCY CHINA  
  6. NLS_NUMERIC_CHARACTERS      .,  
  7. NLS_CALENDAR GREGORIAN  
  8. NLS_DATE_FORMAT    DD-MON-RR  
  9. NLS_DATE_LANGUAGE        SIMPLIFIED CHINESE  
  10. NLS_CHARACTERSET AL32UTF8  
  11. NLS_SORT BINARY  
  12. NLS_TIME_FORMAT     HH.MI.SSXFF AM  
  13. NLS_TIMESTAMP_FORMAT   DD-MON-RR HH.MI.SSXFF AM  
  14. NLS_TIME_TZ_FORMAT       HH.MI.SSXFF AM TZR  
  15. NLS_TIMESTAMP_TZ_FORMAT      DD-MON-RR HH.MI.SSXFF AM TZR  
  16. NLS_DUAL_CURRENCY       RMB  
  17. NLS_NCHAR_CHARACTERSET     UTF8  
  18. NLS_COMP        BINARY  
  19. NLS_LENGTH_SEMANTICS   BYTE  
  20. NLS_NCHAR_CONV_EXCP   FALSE 

How to query the Oracle Character Set

Oracle has three character sets: one is the character set on the El server side, the other is the character set on the Oracle client side, and the other is the dmp file character set. During data import, the three character sets must be consistent before the data can be correctly imported.

1. view the character set of the kernel El server.

 
 
  1. select userenv('language') from dual;  
  2. SIMPLIFIED CHINESE_CHINA.AL32UTF8 

2. view the dmp file Character Set

The dmp file exported using Oracle's exp tool also contains character set information. The 2nd and 3rd bytes of the dmp file record the character set of the dmp file. If the dmp file is not large, for example, only a few MB or dozens of MB, you can use UltraEdit to open it (in hexadecimal mode) and view the content of 2nd 3rd bytes, such as 0354, then, use the following SQL statement to find the corresponding character set:

 
 
  1. select nls_charset_name(to_number('0354','xxxx')) from dual 

3. view the character set of the Oracle client

Is the NLS_LANG of the corresponding OracleHome in the registry. You can also set it in the dos window. For example, set nls_lang = AMERICAN_AMERICA.ZHS16GBK only affects the environment variables in the window. The Oracle character set is described above.

  1. Analysis and Discussion on Oracle Database Restoration
  2. Oracle remote disk image
  3. New Oracle 11g function display
  4. Detailed analysis of Oracle XML data
  5. Oracle Data Guard

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.