t*i
2 楼
I need to remove this special character '¿' from a column. it was
brought to database by copy/paste from MS world. We are using character set
AL32UTF8. Anyone has an idea how to do this? Oracle 10.2.
thanks!
brought to database by copy/paste from MS world. We are using character set
AL32UTF8. Anyone has an idea how to do this? Oracle 10.2.
thanks!
i*a
4 楼
can you so something like
update tbl
set col = replace(col, '¿', '')
update tbl
set col = replace(col, '¿', '')
t*i
6 楼
Maja, thanks for your input!
I did try the replace function, it worked for me at other characters, such
as 'Ã','Â','¢','¯','¤','â', but not on this
one. So I did some research, and found out in AL32UTF8, there are several
codes represent this very similar character. What I found are chr(49795) ,
chr(49794), chr(49792), chr(49816). And I know there are more.
is there a code map out there for these 5 digits characters?
I did try the replace function, it worked for me at other characters, such
as 'Ã','Â','¢','¯','¤','â', but not on this
one. So I did some research, and found out in AL32UTF8, there are several
codes represent this very similar character. What I found are chr(49795) ,
chr(49794), chr(49792), chr(49816). And I know there are more.
is there a code map out there for these 5 digits characters?
i*a
8 楼
what about, instead of removing this one special character, try removing
anything that's not in the printable ASCII range?
such
several
,
【在 t*********i 的大作中提到】
: Maja, thanks for your input!
: I did try the replace function, it worked for me at other characters, such
: as 'Ã','Â','¢','¯','¤','â', but not on this
: one. So I did some research, and found out in AL32UTF8, there are several
: codes represent this very similar character. What I found are chr(49795) ,
: chr(49794), chr(49792), chr(49816). And I know there are more.
: is there a code map out there for these 5 digits characters?
anything that's not in the printable ASCII range?
such
several
,
【在 t*********i 的大作中提到】
: Maja, thanks for your input!
: I did try the replace function, it worked for me at other characters, such
: as 'Ã','Â','¢','¯','¤','â', but not on this
: one. So I did some research, and found out in AL32UTF8, there are several
: codes represent this very similar character. What I found are chr(49795) ,
: chr(49794), chr(49792), chr(49816). And I know there are more.
: is there a code map out there for these 5 digits characters?
t*i
12 楼
Thanks all. But I am always a little confused about the concept of '
printable' when I searched online in the last a few days. Does printable or
non-printable simply mean those characters can be print out? I tried to
write a PL/SQL to print out all charater form chr(1) to chr(10000), and did
see many characters could not show. But specifically for these 5 digits code
like 49816, 49792, they actually were printed out but look like garbage
characters. Any one could clear me out of this?
on the ot
printable' when I searched online in the last a few days. Does printable or
non-printable simply mean those characters can be print out? I tried to
write a PL/SQL to print out all charater form chr(1) to chr(10000), and did
see many characters could not show. But specifically for these 5 digits code
like 49816, 49792, they actually were printed out but look like garbage
characters. Any one could clear me out of this?
on the ot
i*a
14 楼
ASCII printable character are basically the regular characters you can
type form a standard english keyboard.
your 2nd question, that needs analysis of the actual data with your
business unit, or who speaks those foreign languages
printable or
to
and did
digits code
garbage
foreign
'garbage
【在 t*********i 的大作中提到】
: Thanks all. But I am always a little confused about the concept of '
: printable' when I searched online in the last a few days. Does printable or
: non-printable simply mean those characters can be print out? I tried to
: write a PL/SQL to print out all charater form chr(1) to chr(10000), and did
: see many characters could not show. But specifically for these 5 digits code
: like 49816, 49792, they actually were printed out but look like garbage
: characters. Any one could clear me out of this?
: on the ot
type form a standard english keyboard.
your 2nd question, that needs analysis of the actual data with your
business unit, or who speaks those foreign languages
printable or
to
and did
digits code
garbage
foreign
'garbage
【在 t*********i 的大作中提到】
: Thanks all. But I am always a little confused about the concept of '
: printable' when I searched online in the last a few days. Does printable or
: non-printable simply mean those characters can be print out? I tried to
: write a PL/SQL to print out all charater form chr(1) to chr(10000), and did
: see many characters could not show. But specifically for these 5 digits code
: like 49816, 49792, they actually were printed out but look like garbage
: characters. Any one could clear me out of this?
: on the ot
t*i
16 楼
That is what I thought. thank you.
【在 i****a 的大作中提到】
: ASCII printable character are basically the regular characters you can
: type form a standard english keyboard.
: your 2nd question, that needs analysis of the actual data with your
: business unit, or who speaks those foreign languages
:
: printable or
: to
: and did
: digits code
: garbage
【在 i****a 的大作中提到】
: ASCII printable character are basically the regular characters you can
: type form a standard english keyboard.
: your 2nd question, that needs analysis of the actual data with your
: business unit, or who speaks those foreign languages
:
: printable or
: to
: and did
: digits code
: garbage
相关阅读
Need help designing a table.Help! How to deal with SYNONYME in MySQLWIN XP下如何让MYSQL不自动启动mysql索引/优化的一个问题[转载] 急问这里的大虾们一个技术问题sql 比access好吗?问一个SQL的问题[转载] Help on getting large data from OracleHow can I learn Paradox?excel怎么做批量运算mysql安装问题:(有啥好的SAS的书推荐,谢谢Re: In SQLPLUS, how to repeat typed comm哭求:Oracle OCP 认证复习资料pull-down menu in Access forms请问MYSQL JDBC如何获得插入记录的编号How to write logger of SP?Question about the err when export tableSQL 怎样和empty string 做比较阿Oracle 是否适合做这样的工作?