Oracle字符集的简单图解,中文乱码解决(2)

PROD5的结果如下,此时PROD5显示正常

[oracle@oddpc ~]$ export NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8" [oracle@oddpc ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on 星期四 10月 13 15:46:36 2016 Copyright (c) 1982, 2011, Oracle. All rights reserved. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> show parameter db_name NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ db_name string PROD5 SQL> select sysdate from dual; SYSDATE ------------ 13-10月-16 SQL> show parameter lang NAME TYPE VALUE ------------------------------------ --------------------------------- ------------------------------ nls_date_language string SIMPLIFIED CHINESE nls_language string SIMPLIFIED CHINESE<pre>SQL> select * from nls_database_parameters; PARAMETER VALUE ---------------------------------------- ---------------------------------------- NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET AL32UTF8 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM PARAMETER VALUE ---------------------------------------- ---------------------------------------- NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR NLS_DUAL_CURRENCY $ NLS_COMP BINARY NLS_LENGTH_SEMANTICS BYTE NLS_NCHAR_CONV_EXCP FALSE NLS_NCHAR_CHARACTERSET AL16UTF16 NLS_RDBMS_VERSION 11.2.0.3.0 已选择20行。  


总结:通过以上的实验可以看出,客户端展现是否乱码是由NLS_LANG决定,发生中文乱码的情况下,首先查看数据库的NLS_CHARACTERSET是否支持中文存储,如果不支持,无论如何设置均无法正常显示中文。Oracle官方文档上给出了各种语言的编码支持如下。



#NLSPG593

Table A-13 Languages and Character Sets Supported by LCSSCAN and GDK

LanguageCharacter Sets

Arabic

 

AL16UTF16, AL32UTF8, AR8ISO8859P6, AR8MSWIN1256, UTF8

 

Bulgarian

 

AL16UTF16, AL32UTF8, CL8ISO8859P5, CL8MSWIN1251, UTF8

 

Catalan

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Croatian

 

AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8

 

Czech

 

AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8

 

Danish

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Dutch

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

English

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Estonian

 

AL16UTF16, AL32UTF8, NEE8IOS8859P4, UTF8

 

Finnish

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

French

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

German

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Greek

 

AL16UTF16, AL32UTF8, EL8ISO8859P7, EL8MSWIN1253, UTF8

 

Hebrew

 

AL16UTF16, AL32UTF8, IW8ISO8859P8, IW8MSWIN1255, UTF8

 

Hindi

 

AL16UTF16, AL32UTF8, IN8ISCII, UTF8

 

Hungarian

 

AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8

 

Indonesian

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Italian

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Japanese

 

AL16UTF16, AL32UTF8, ISO2022-JP, JA16EUC, JA16SJIS, UTF8

 

Korean

 

AL16UTF16, AL32UTF8, ISO2022-KR, KO16KSC5601, KO16MSWIN949, UTF8

 

Latvian

 

AL16UTF16, AL32UTF8, NEE8ISO8859P4, UTF8

 

Lithuanian

 

AL16UTF16, AL32UTF8, NEE8ISO8859P4, UTF8

 

Malay

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Norwegian

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Persian

 

AL16UTF16, AL32UTF8, AR8MSWIN1256, UTF8

 

Polish

 

AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8

 

Portuguese

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Romanian

 

AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8

 

Russian

 

AL16UTF16, AL32UTF8, CL8ISO8859P5, CL8KOI8R, CL8MSWIN1251, RU8PC866, UTF8

 

Serbian

 

AL16UTF16, AL32UTF8, CL8ISO8859P5, CL8MSWIN1251, UTF8

 

Simplified Chinese

 

AL16UTF16, AL32UTF8, HZ-GB-2312, UTF8, ZHS16GBK, ZHS16CGB231280

 

Slovak

 

AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8

 

Slovenian

 

AL16UTF16, AL32UTF8, EE8ISO8859P2, EE8MSWIN1250, UTF8

 

Spanish

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Swedish

 

AL16UTF16, AL32UTF8, US7ASCII, UTF8, WE8ISO8859P1, WE8ISO8859P15, WE8MSWIN1252

 

Thai

 

AL16UTF16, AL32UTF8, TH8TISASCII, UTF8

 

Traditional Chinese

 

AL16UTF16, AL32UTF8, UTF8, ZHT16MSWIN950

 

Turkish

 

AL16UTF16, AL32UTF8, TR8MSWIN1254, UTF8, WE8ISO8859P9

 

Ukranian

 

AL16UTF16, AL32UTF8, CL8ISO8859P5, CL8MSWIN1251, UTF8

 

Vietnamese

 

AL16UTF16, AL32UTF8, VN8VN3, UTF8

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/76d39ba2b69b93ddbbf2a3e7f082d765.html