I find that in my oracle database there have some non-printable character, so I try to use regexp_replace to remove the non-printable characters as below:
`select common_name before_value,
regexp_replace(common_name, '[^[:print:]]', '?') after_reg_value
from my_data;`
result as below:
before_value after_reg_value
------------------------------------------
Verm�gensstrukt Verm?gensstrukt
DG HYP �FE DG HYP �FE
KL�KNER KL�KNER
BGF GHYB X2 �H BGF GHYB X2 ?H
7.77% Cr�t Agr 7.77% Cr?t Agr
PUBLIC STO� PUBLIC STO?
M�nchener R�ck A M?nchener R?ck A
from the result we can see that, some non-printable characters are been replace by '?', but others didn't.
select dump(common_name,1016) value
from my_data;
value
----------------------------------------------------------------------------
Typ=1 Len=15 CharacterSet=UTF8: 56,65,72,6d,f6,67,65,6e,73,73,74,72,75,6b,74
Typ=1 Len=11 CharacterSet=UTF8: 44,47,20,48,59,50,20,d6,50,46,45
Typ=1 Len=8 CharacterSet=UTF8: 4b,4c,d6,43,4b,4e,45,52
Typ=1 Len=14 CharacterSet=UTF8: 42,47,46,20,47,48,59,42,20,58,32,20,a3,48
Typ=1 Len=16 CharacterSet=UTF8: 37,2e,37,37,25,20,43,72,e9,64,69,74,20,41,67,72
Typ=1 Len=12 CharacterSet=UTF8: 50,55,42,4c,49,43,20,53,54,4f,c3,3f
Typ=1 Len=16 CharacterSet=UTF8: 4d,fc,6e,63,68,65,6e,65,72,20,52,fc,63,6b,20,41
from the dump result we can find that:
In 'Verm�gensstrukt' the � was translate to 'f6' who can be repleace by '?'
while in 'DG HYP �FE' the � was translate to 'd6, 50', who didn't been find.
Can you help me to find a solution to filter out all the � ?
分享到:
相关推荐
Oracle SQL:经典查询练手四篇Oracle SQL:经典查询练手四篇Oracle SQL:经典查询练手四篇
Oracle疑难:session无法完全删除问题
《大话Oracle RAC:集群 高可用性 备份与恢复》以Oracle 10g为基础,对Oracle RAC进行了全面的介绍和分析。全书分为两个部分,共14章,第1部分是集群理论篇,这部分从集群基础知识入手,通过分析集群环境和单机环境...
Oracle9i: Program with PL/SQL 学生指导用书,初学者必备资料<英文版>
Oracle 修改字符集Oracle 修改字符集Oracle 修改字符集
-- oracle数据库驱动 --> <groupId>com.oracle</groupId> <artifactId>ojdbc6 <version>11.2.0.1.0 1.首先确定你是否有安装oracle,如果有安装的话,找到ojdbc6.jar包 D:\app\Administrator\product\...
oracle 字符集修改命令oracle 字符集修改命令oracle 字符集修改命令oracle 字符集修改命令
oracle过滤数字oracle过滤数字
Oracle批处理:使用C# 自带Oracle驱动一次执行多条Sql语句
教程名称:盖国强Oracle专题:天道酬勤oracle之路课程目录:【】Oracle DBA 手记3,数据库性能优化与内部原理解析【】Oracle数据安全-盖国强(DTCC2012)【】Oracle数据库DBA专题技术精粹【】Oracle数据库性能优化...
大话Oracle RAC:集群、高可用性、备份与恢复(带目录清晰中文完整版)
Oracle Form 开发教学 R11i Extend Oracle Applications: Forms
oracle字符集的查看,oracle客户端字符集的修改
Oracle字符相似度函数。在sql语句中直接用该函数来计算2个字符串相似度。
Oracle 字符集详解,包括查看,修改,导入导出,转换原理
oracle,按特定字符,截取字符串,直接出结果 oracle,按特定字符,截取字符串,直接出结果oracle,按特定字符,截取字符串,直接出结果
oracle只能手动添加jar包 下载 sdoapi-11.2.0.jar 包到本地 cmd,将jar包手动添加至本地仓库 mvn install:install-file -DgroupId=oracle -DartifactId=sdoapi -Dversion=11.2.0 -Dpackaging=jar -Dfile=E:\Dnloads...
Oracle compatibility ODAC supports Oracle servers 11g, 10g, 9i, 8i, 8.0, and 7.3, including Oracle 10g Express. ODAC supports x86 versions of the following Oracle clients: 11g, 10g, 9i, 8i, 8.0, and ...
40057GC11 - Introduction to Oracle9i:SQL Basics Tutorial
大话Oracle RAC:集群、高可用性、备份与恢复。 此书被认为不可多得的好资料之一:大话Oracle RAC(PDF经典),看完之后深有感触,发出来共享一下。