Shulou(Shulou.com)06/01 Report--

After the local ORACLE connection is created, the default is the GBK character set. If the connection server is not the same GBK character set, there will be a problem of garbled Chinese characters. In this case, we need to modify the local character set to match the server.

Modify through the registry

HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0

Change NLS_LANG to the character set you need.

Set environment variabl

Add the environment variable-NLS_LANG to the character set you need

Common character set

AMERICAN_AMERICA.WE8ISO8859P1

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

AMERICAN_AMERICA.AL32UTF8

SIMPLIFIED CHINESE_CHINA.US7ASCII

AMERICAN_AMERICA.US7SCII

AMERICAN _ AMERICA. ZHS16GBK

AMERICAN_AMERICA.utf8

Now, introduce some NLS_LANG parameters related to the character set

NLS_LANG format:

NLS_LANG = language_territory.charset

There are three components (language, region, and character set), each of which controls the characteristics of the NLS subset. Where: language specifies the language of the server message.

Territory specifies the date and number format of the server.

Charset specified character set

For example:

AMERICAN_AMERICA.US7SCII

AMERICAN _ AMERICA. ZHS16GBK

There are also subsets that can define NLS_LANG parameters more clearly:

DICT.BASE data Dictionary basic Table version

DBTIMEZONE database time zone

NLS_LANGUAGE language

NLS_TERRITORY region

NLS_CURRENCY local currency character

NLS_ISO_CURRENCY ISO currency character

NLS_NUMERIC_CHARACTERS decimal characters are separated from groups

NLS_CHARACTERSET character set

NLS_CALENDAR calendar system

Default date format for NLS_DATE_FORMAT

NLS_DATE_LANGUAGE default date language

NLS_SORT character sort sequence

NLS_TIME_FORMAT time format

NLS_TIMESTAMP_FORMAT timestamp format

Attachment: http://down.51cto.com/data/2366159

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.