NLS_LANG is used to set the character set of the client. The language affects the SQLPLUS interface.
Regedit: HKEY_LOCAL_MACHINE / SOFTWARE / ORACAL_MACHINE / SOFTWARE / ORACLE / HOME0NLS_LANG key value 1, the value is 'US7ASCII' or the empty 2, the value is 'Simplified Chinese_China.zHS16GBK'
NLS_CharacTerSet is used to set the database internal character set to determine the format saved in the data record. 1. Value is 'US7ASCII' or is empty 2, with a value of 'zhs16GBK'
Test: Environment (already already Test_Char. With Chinese characters) 1> Client, server-side character set is zhs16GBK:. It can display Test_char correctly.. Correctly build a table containing Chinese characters. Import Xiejia.Test_char into the mode TEST exported zhs16GBK character set and AL16UTF16 NCHAR character set
2> The client is zhs16GBK, the internal character set of the server is US7ASCII. Test_char is not displayed properly. After building a table with Chinese characters record, the content cannot be displayed. During execution of the Export. The exported zhs16GBK character set and the Al16UTF16 NCHAR character set server uses the US7ASCII character set (possible character set conversion)
3> The client is US7ASCII, the internal character set of the server is US7asii. It can display Test_Char normally. After building a table with Chinese characters record, the content cannot be displayed. Export Done in US 7ASCII Character set and al16utf16 nchar character set and al16utf16 nchar character SET does not display the import content normally after executing the Import process
4> The client is ZHS16GBK, the internal character set of the server is US7ASCII. It is not possible to display Test_Char. After the establishment of the Chinese characters recorded, the content cannot be displayed normally. Export Done in US 7ASCII Character set and al16utf16 nchar character in executive Export Done in US Ncharacter set Set Server Uses ZHS16GBK Character Set (Possible Charset Conversion)
Summary: The client setting ULS_LANG can derive the character set.
In the Oracle9i database, the client character set must match the type of database core character set, otherwise Chinese characters appear garbled
