1. What is
Oracle
Character SetThe 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.
Select*
FromV $ nls_parameters1 nls_language simplified chinese2 nls_territory china3 nls_currency RMB4 nls_iso_currency china5 nls_numeric_characters ., 6 nls_calendar gregorian7 nls_date_format DD-MON-RR8 nls_date_language simplified chinese9 nls_characterset al32utf810 nls_sort binary11 nls_time_format HH. mi. ssxff Am12 nls_timestamp_format DD-MON-RR HH. mi. ssxff am13 nls_time_tz_format HH. mi. ssxff am tzr14 nls_timestamp_tz_format DD-MON-RR HH. mi. ssxff am tzr15 nls_dual_currency rmb16 nls_nchar_characterset utf817 nls_comp binary18 nls_length_semantics byte19 nls_nchar_conv_excp false
Ii. How to query
Oracle
Character SetOracle has three character sets: character set at the kernel El server side and Oracle
ClientCharacter set. The third is the character set of the DMP file. During data import, the three character sets must be consistent before the data can be correctly imported. -- View the character set of the kernel El Server
SelectUserenv ('language ')
FromDual; 1 Simplified chinese_china.al32utf8 -- the DMP file exported by Oracle exp tool to view the DMP file Character Set also contains the character set information, the 2nd and 3rd bytes of the DMP file record the DMP file character set. 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:
SelectNls_charset_name (to_number ('123', 'xxxx '))
FromDual -- check that the character set of the guest El 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.
