ORACLE character set

-
1. 数据库服务器端字符集
建立数据库最好决定字符集类型，一般不推荐建立后修改。
修改方法: 如果需要修改字符集，通常需要重建数据库，通过导入导出的方式来转换。

修改字符集
SQL>startup mount
SQL> alter system enable restricted session;
系统已更改。
SQL> alter system set job_queue_processes=0;
系统已更改。
SQL> alter system set aq_tm_processes=0;
系统已更改。
SQL> alter database open;
数据库已更改。
SQL> ALTER DATABASE character set INTERNAL_USE AL32UTF8;
数据库已更改。

更改后
10g以上使用csscan字符扫描工具验证,先@$ORACLE_HOME\RDBMS\ADMIN\csminst.sql

推荐字符集
如果存储信息包含中文最好为ZHS16GBK或者UTF-8

查看服务器端字符集：
SQL>select name, value$ from props$ where name = 'NLS_CHARACTERSET';

如果服务器端为WINDOWS操作系统
注册表设置：
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
找到以下字符串 NLS_LANG
设置和服务器端一致。
例如：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

2. 数据库客户段字符集
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
找到以下字符串 NLS_LANG
设置和服务器端一致。
例如：SIMPLIFIED CHINESE_CHINA.ZHS16GBK

字符集对应关系
A. Current Char set             B. New Char set (Superset of A.)
-------------------             --------------------------------
US7ASCII                        WE8DEC
US7ASCII                        US8PC437
US7ASCII                        WE8PC850
US7ASCII                        IN8ISCII
US7ASCII                        WE8PC858
US7ASCII                        WE8ISO8859P1
US7ASCII                        EE8ISO8859P2
US7ASCII                        SE8ISO8859P3
US7ASCII                        NEE8ISO8859P4
US7ASCII                        CL8ISO8859P5
US7ASCII                        AR8ISO8859P6
US7ASCII                        EL8ISO8859P7
US7ASCII                        IW8ISO8859P8
US7ASCII                        WE8ISO8859P9
US7ASCII                        NE8ISO8859P10
US7ASCII                        TH8TISASCII
US7ASCII                        BN8BSCII
US7ASCII                        VN8VN3
US7ASCII                        VN8MSWIN1258
US7ASCII                        WE8ISO8859P15
US7ASCII                        WE8NEXTSTEP
US7ASCII                        AR8ASMO708PLUS
US7ASCII                        EL8DEC
US7ASCII                        TR8DEC
US7ASCII                        LA8PASSPORT
US7ASCII                        BG8PC437S
US7ASCII                        EE8PC852
US7ASCII                        RU8PC866
US7ASCII                        RU8BESTA
US7ASCII                        IW8PC1507
US7ASCII                        RU8PC855
US7ASCII                        TR8PC857
US7ASCII                        CL8MACCYRILLICS
US7ASCII                        WE8PC860
US7ASCII                        IS8PC861
US7ASCII                        EE8MACCES
US7ASCII                        EE8MACCROATIANS
US7ASCII                        TR8MACTURKISHS
US7ASCII                        EL8MACGREEKS
US7ASCII                        IW8MACHEBREWS
US7ASCII                        EE8MSWIN1250
US7ASCII                        CL8MSWIN1251
US7ASCII                        ET8MSWIN923
US7ASCII                        BG8MSWIN
US7ASCII                        EL8MSWIN1253
US7ASCII                        IW8MSWIN1255
US7ASCII                        LT8MSWIN921
US7ASCII                        TR8MSWIN1254
US7ASCII                        WE8MSWIN1252
US7ASCII                        BLT8MSWIN1257
US7ASCII                        N8PC865
US7ASCII                        BLT8CP921
US7ASCII                        LV8PC1117
US7ASCII                        LV8PC8LR
US7ASCII                        LV8RST104090
US7ASCII                        CL8KOI8R
US7ASCII                        BLT8PC775
US7ASCII                        WE8DG
US7ASCII                        WE8NCR4970
US7ASCII                        WE8ROMAN8
US7ASCII                        WE8MACROMAN8S
US7ASCII                        TH8MACTHAIS
US7ASCII                        HU8CWI2
US7ASCII                        EL8PC437S
US7ASCII                        LT8PC772
US7ASCII                        LT8PC774
US7ASCII                        EL8PC869
US7ASCII                        EL8PC851
US7ASCII                        CDN8PC863
US7ASCII                        HU8ABMOD
US7ASCII                        AR8ASMO8X
US7ASCII                        AR8NAFITHA711T
US7ASCII                        AR8SAKHR707T
US7ASCII                        AR8MUSSAD768T
US7ASCII                        AR8ADOS710T
US7ASCII                        AR8ADOS720T
US7ASCII                        AR8APTEC715T
US7ASCII                        AR8NAFITHA721T
US7ASCII                        AR8HPARABIC8T
US7ASCII                        AR8NAFITHA711
US7ASCII                        AR8SAKHR707
US7ASCII                        AR8MUSSAD768
US7ASCII                        AR8ADOS710
US7ASCII                        AR8ADOS720
US7ASCII                        AR8APTEC715
US7ASCII                        AR8MSAWIN
US7ASCII                        AR8NAFITHA721
US7ASCII                        AR8SAKHR706
US7ASCII                        AR8ARABICMACS
US7ASCII                        LA8ISO6937
US7ASCII                        JA16VMS
US7ASCII                        JA16EUC
US7ASCII                        JA16SJIS
US7ASCII                        KO16KSC5601
US7ASCII                        KO16KSCCS
US7ASCII                        KO16MSWIN949
US7ASCII                        ZHS16CGB231280
US7ASCII                        ZHS16GBK
US7ASCII                        ZHT32EUC
US7ASCII                        ZHT32SOPS
US7ASCII                        ZHT16DBT
US7ASCII                        ZHT32TRIS
US7ASCII                        ZHT16BIG5
US7ASCII                        ZHT16CCDC
US7ASCII                        ZHT16MSWIN950
US7ASCII                        AL24UTFFSS
US7ASCII                        UTF8
US7ASCII                        JA16TSTSET2
US7ASCII                        JA16TSTSET
8.1.7 Additions
===============
US7ASCII                        ZHT16HKSCS 
US7ASCII                        KO16TSTSET 
WE8DEC                          TR8DEC 
WE8DEC                          WE8NCR4970 
WE8PC850                        WE8PC858 
D7DEC                           D7SIEMENS9780X 
I7DEC                           I7SIEMENS9780X 
WE8ISO8859P1                    WE8MSWIN1252 
AR8ISO8859P6                    AR8ASMO708PLUS 
AR8ISO8859P6                    AR8ASMO8X 
IW8EBCDIC424                    IW8EBCDIC1086 
IW8EBCDIC1086                   IW8EBCDIC424 
LV8PC8LR                        LV8RST104090 
DK7SIEMENS9780X                 N7SIEMENS9780X 
N7SIEMENS9780X                  DK7SIEMENS9780X 
I7SIEMENS9780X                  I7DEC 
D7SIEMENS9780X                  D7DEC 
WE8NCR4970                      WE8DEC 
WE8NCR4970                      TR8DEC 
AR8SAKHR707T                    AR8SAKHR707 
AR8MUSSAD768T                   AR8MUSSAD768 
AR8ADOS720T                     AR8ADOS720 
AR8NAFITHA711                   AR8NAFITHA711T 
AR8SAKHR707                     AR8SAKHR707T 
AR8MUSSAD768                    AR8MUSSAD768T 
AR8ADOS710                      AR8ADOS710T 
AR8ADOS720                      AR8ADOS720T 
AR8APTEC715                     AR8APTEC715T 
AR8NAFITHA721                   AR8NAFITHA721T 
AR8ARABICMAC                    AR8ARABICMACT 
AR8ARABICMACT                   AR8ARABICMAC 
KO16KSC5601                     KO16MSWIN949 
WE16DECTST2                     WE16DECTST 
WE16DECTST                      WE16DECTST2 
  
9.0.1 Additions
===============
US7ASCII                        BLT8ISO8859P13 
US7ASCII                        CEL8ISO8859P14 
US7ASCII                        CL8ISOIR111 
US7ASCII                        CL8KOI8U 
US7ASCII                        AL32UTF8 
BLT8CP921                       BLT8ISO8859P13 
US7ASCII                        AR8MSWIN1256 
UTF8                            AL32UTF8 (added in patchset 9.0.1.2)
Character Set Subset/Superset Pairs Obsolete from 9.0.1
=======================================================
US7ASCII                        AR8MSAWIN
AR8ARABICMAC                    AR8ARABICMACT
9.2.0 Additions
===============
US7ASCII                        JA16EUCTILDE
US7ASCII                        JA16SJISTILDE
US7ASCII                        ZHS32GB18030
US7ASCII                        ZHT32EUCTST
WE8ISO8859P9                    TR8MSWIN1254
LT8MSWIN921                     BLT8ISO8859P13
LT8MSWIN921                     BLT8CP921
BLT8CP921                       LT8MSWIN921
AR8ARABICMAC                    AR8ARABICMACT
ZHT32EUC                        ZHT32EUCTST
UTF8                            AL32UTF8
Character Set Subset/Superset Pairs Obsolete from 9.2.0
=======================================================
LV8PC8LR                        LV8RST104090

Comments

Post a Comment

Popular posts from this blog

Nginx Proxy & Load Balance & LNMP

-
Nginx Proxy Service E-commerce website Server 1: provide image request response (  apache / nginx ) Server 2: provide dynamic request response ( php-fpm / apache-php ) Server 3: provide static request response ( apache / nginx ) Server 4: provide data request response ( mysql ) It need one additional nginx server 1. Install nginx 2. proxy to specific server Example location / {      proxy_pass http://192.168.199.187:80/; } location /bbs/ {      proxy_pass http://192.168.199.187:80/bbs/; } location ~* \.(jpg|png|gif)$  {      proxy_pass http://172.16.100.7; } Enhance the log information and specific the hostname location / {      proxy_pass  http://192.168.199.187:80/;      proxy_set_header <parameter name>  $host;  (client requst the hostname )      proxy_set_header <parameter name> $remote_addr; ...
Read more

Snort+barnyard2+Snorby CentOS 6.5_64 Installation

-
#download packages: daq-2.0.2.tar.gz ImageMagicK-6.8.9-8.tar.gz oinkmaster-2.0.tar.gz ruby-1.9.3-p547.tar.gz snort-2.9.6.2.tar.gz snortrules-snapshot-2962.tar.gz MySQL-server-5.5.40-1.rhel5.x86_64.rpm MySQL-client-5.6.21-1.rhel5.x86_64.rpm MySQL-devel-5.6.21-1.rhel5.x86_64.rpm MySQL-shared-5.6.21-1.rhel5.x86_64.rpm epel-release-6-8.noarch.rpm barnyard2-2.1.13.tar.gz #install yum package rpm -ivh epel-release-6-8.noarch.rpm yum install gcc-c++ patch readline readline-devel zlib zlib-devel flex git yum install libyaml-devel libffi-devel openssl-devel make  yum install bzip2 autoconf automake libtool bison iconv-devel libxml2-devel libxslt  yum install gcc g++ build-essential libssl-devel libreadline5-devel zlib1g-devel linux-headers-generic libsqlite3-devel libxslt-devel curl-devel sqlite-devel yum --enablerepo=epel install jasper jasper-libs jasper-devel #Mysql install yum remove mysql mysql-libs rpm -ivh MySQL-server-5.5.40-1.rh...
Read more

ORACLE Error

-
Image
oracle official error explanation  http://docs.oracle.com/cd/E11882_01/server.112/e17766/toc.htm 从服务器下载ALERT日志文件，传输方式需要选择"ASCII" ORA-01078: failure in processing system parameters 发生场景：新建数据库第一次启动时 SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’ 原因：oracle_sid没有配置正确 解决方案： 1. 修改oracle用户.bash_profile文件中ORACLE_SID后的内容； 2. 重新已oracle用户登录； ORA-01157: cannot identify/lock data file string - see DBWR trace file  Cause: The background process was either unable to find one of the data files or failed to lock it because the file was already in use. The database will prohibit access to this file but other files will be unaffected. However the first instance to open the database will need to access all online data files. Accompanying error from the operating system describes why the file could not be identified. Action: Have operating system make file ...
Read more