Oracle client language Settings, Sqlplus garbled solution

Client Environment parameters

Nls_lang = Language_territory. Character_set

Description is as follows

Parameter Description

LANGUAGE Specifies the LANGUAGE and conventions for displaying messages, day name, and month name.

TERRITORY Specifies the TERRITORY and conventions for calculating week and day numbers.

Character_set Controls the CHARACTER SET used for displaying messages.

Translation

Language (language) specifies the language and converts the display information, date, and month to the idiomatic way of the language

Territory (region) specifies the region and calculates the customary way of converting the Sunday period into such a region.

The Character_set (character set) control character set is used to display information.

* * Set as US English _ US _al32utf8 character Sets * *

Export Nls_lang=american_america. Al32utf8

The following table is a common setting

Operating System Locale	Nls_lang Value
Arabic (U.A.E.)	arabic_united ARAB EMIRATES. ar8mswin1256
Bulgarian	Bulgarian_bulgaria. cl8mswin1251
Catalan	Catalan_catalonia. we8mswin1252
Chinese (PRC)	Simplified Chinese_china. Zhs16gbk
Chinese (Taiwan)	Traditional Chinese_taiwan. zht16mswin950
Croatian	Croatian_croatia. ee8mswin1250
Czech	Czech_czech REPUBLIC. ee8mswin1250
Danish	Danish_denmark. we8mswin1252
Dutch (Netherlands)	Dutch_the Netherlands. we8mswin1252
中文版 (Kingdom)	English_united Kingdom. we8mswin1252
中文版 (states)	American_america. we8mswin1252
Estonian	Estonian_estonia. blt8mswin1257
Finnish	Finnish_finland. we8mswin1252
French (Canada)	CANADIAN French_canada. we8mswin1252
French (France)	French_France. we8mswin1252
German (Germany)	German_germany. we8mswin1252
Greek	Greek_greece. el8mswin1253
Hebrew	Hebrew_israel. iw8mswin1255
Hungarian	Hungarian_hungary. ee8mswin1250
Icelandic	Icelandic_iceland. we8mswin1252
Indonesian	Indonesian_indonesia. we8mswin1252
Italian (Italy)	Italian_italy. we8mswin1252
Japanese	Japanese_japan. Ja16sjis
Korean	Korean_korea. ko16mswin949
Latvian	Latvian_latvia. blt8mswin1257
Lithuanian	Lithuanian_lithuania. blt8mswin1257
Norwegian	Norwegian_norway. we8mswin1252
Polish	Polish_poland. ee8mswin1250
Portuguese (Brazil)	Brazilian Portuguese_brazil. we8mswin1252
Portuguese (Portugal)	Portuguese_portugal. we8mswin1252
Romanian	Romanian_romania. ee8mswin1250
Russian	Russian_cis. cl8mswin1251
Slovak	Slovak_slovakia. ee8mswin1250
Spanish (Spain)	Spanish_spain. we8mswin1252
Swedish	Swedish_sweden. we8mswin1252
Thai	Thai_thailand. Th8tisascii
Spanish (Mexico)	MEXICAN Spanish_mexico. we8mswin1252
Spanish (Venezuela)	LATIN AMERICAN Spanish_venezuela. we8mswin1252
Turkish	Turkish_turkey. tr8mswin1254
Ukrainian	Ukrainian_ukraine. cl8mswin1251
Vietnamese	Vietnamese_vietnam. vn8mswin1258

Oracle client language Settings, Sqlplus garbled solution