要学会怎么设置nls_lang,首先要了解它的构成,下面是官档的内容:
NLS_LANG has the syntax:
NLS_LANG = language_territory.charsetwhere language specifies the conventions to use for Oracle Database messages, sorting order, day and month names. For example, to receive messages in Japanese, setlanguage to JAPANESE. Iflanguage is not set, it defaults to AMERICAN.
where territory specifies the convention for default dates, and for monetary, and numeric formats. For example to use the Japanese territory format, setterritory to JAPAN. Ifterritory is not set, the default value is derived from the language value, and so is set to AMERICA.
NLS_LANG=JAPANESE_JAPAN.AL32UTF8其他的不说,这个NLS__LANG必须和客户端的字符集设置成一样。不然可能在以会出现很大的问题。