Oracle view character set, and handling of garbled characters in Chinese

Col VALUE format A20

Select Parameter,value from nls_database_parameters where PARAMETER like '%characterset% ';

PARAMETER VALUE--------------------------------------------------nls_characterset Al32utf8nls_nchar_cha Racterset AL16UTF16

Select Userenv (' language ') from dual;

USERENV (' LANGUAGE ')----------------------------------------------------American_america. Al32utf8

Lang is a set of languages, regions, and character sets for Linux systems, which are valid for applications under Linux, such as date;

Nls_lang is a setting for Oracle language, region, and character set that works with tools in Oracle

Export Nls_lang=american_america. Zhs16gbk

Export Nls_lang=american_america. UTF8

Export Nls_lang=simplified Chinese_america. UTF8

Lang=en_us. UTF-8

Export lang= zh_cn. GB2312

Export lang= en_US. UTF-8

Locale View Character Set

Locale-a viewing the local character set

Locale-m View all supported character sets

Alter session Set Nls_date_format = ' Yyyy-mm-dd HH24:mi:ss ';

Select To_char (sysdate, ' Yyyy-mm-dd HH24:mi:ss ') from dual;

Select To_date (' 2005-01-01 13:14:20 ', ' yyyy-mm-dd HH24:mi:ss ') from dual;

The way to ensure that Chinese does not garbled:

1, remote Tools, such as the Crt,xshell character set to support the Chinese character set such as Utf-8

2, operating system environment variable settings support Chinese character set, such as Utf-8 LANG or Nls_lang

3. Database supports Chinese character set Utf-8

Oracle view character set, and handling of garbled characters in Chinese