oracle更改编码
背景:win764bit英文操作系统(支持中文)
oracle11G默认安装
从ZHS16GBK字符集导入数据库
表现:plsql显示为乱码,所有汉字显示为“靠”
解决:1、查看并更改数据库的编码为ZHS16GBK
$sqlplus system/oracle
SQL> select * from v$nls_parameters;
PARAMETER VALUE
------------------------ -----------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
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 RMB
NLS_NCHAR_CHARACTERSET UTF8
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
如果 NLS_CHARACTERSET不是ZHS16GBK, 则需进行更改
$ sqlplus /nolog
SQL> connect sys/oracle as sysdba
SQL> startup
如何设置ORACLE数据库的编码(ZHS16GBK)修改成UTF8
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter system enable restricted session;
SQL> alter system set job_queue_processes=0;
SQL> alter database open;
SQL> alter database character set internal_use ZHS16GBK;
SQL> shutdown immediate;
SQL> startup
另外
1.检查下regedit->HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->HOMEO
HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE
NLS_LANG :SIMPLIFIED CHINESE_CHINA.ZHS16GBK
2、设置环境变量,NLS_LANG :SIMPLIFIED CHINESE_CHINA.ZHS16GBK
select *from ts_dict
Exception:ORA-29275: partial multibyte character
此异常是由于不同字符集导入数据时造成。1、重新导入;2、update table set field=trim(field)
REFERENCES:http://blog.csdn.net/lunzi028/article/details/4826982
最新文章
- HTML5和css3的总结
- 第二篇 Replication:分发服务器的作用
- windows 2003 server 远程桌面禁用本地资源,磁盘驱动器,串行口,复制文件
- Informix 中执行多条SQL(Execute Script)
- HDU 3833 YY's new problem(换种思路的模拟,防超时)
- 教你50招提升ASP.NET性能(十四):使用startMode属性来减少ASP.NET站点加载时间
- springmvc的几点见解
- 未在本地计算机上注册Microsoft.ACE.OLEDB.12.0提供程序(Oledb)
- com.android.dex.DexException: Multiple dex files define Lcom/sina/sso/RemoteSSO;
- 【深度学习】RNN | GRU | LSTM
- tornado 初解
- contourf和contour用法区别
- JDBC(5)—DatabaseMetaData
- nginx反向代理 强制https请求
- MySQL 使用profile分析慢sql,group left join效率高于子查询
- Virtualenv教程
- nginx 参考文章汇总
- jsjl_for_ubuntu12.04
- android中的数据库操作(SQLite)
- asp.net 省市联级代码