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

Col VALUE format a20

Select PARAMETER,VALUE from nls_database_parameters where PARAMETER like'% CHARACTERSET%'

PARAMETER VALUE---NLS_CHARACTERSET AL32UTF8NLS_NCHAR_CHARACTERSET AL16UTF16

Select userenv ('language') from dual

USERENV ('LANGUAGE')-AMERICAN_AMERICA.AL32UTF8

LANG is a setting for the language, region, and character set of the Linux system, and is valid for applications under linux, such as date

NLS_LANG is set for Oracle language, region and character set, and is valid for tools in oracle

Export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

Export NLS_LANG=AMERICAN_AMERICA.UTF8 # cannot be set to this. If set to this, sqlplus cannot log in.

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 view 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-14-20-13-14-14-20) from dual

Ways to ensure that Chinese is not garbled:

1. Remote tools, such as CRT,xshell character set, are set to support Chinese character sets such as utf-8

2. Set operating system environment variables to support Chinese character sets, such as utf-8 LANG or NLS_LANG.

3. The database supports Chinese character set utf-8.

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.