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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: 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 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: 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
相关阅读
SQL statement helpWOrst Case Overhead!!!!!面试问题,关于oracle 8iAccess form construction questionmysql maximum columns <=1000?SQL Standardaccess 的tree view 问题how to find duplicates in mysql问一个crystal report的问题Can I use array in SQL stored procedure?[转载] Crystal Report 9 languageimage datatype in sql serverJDBC怎样连接FoxPro数据库?查找中文内容的问题大家能不能推荐一本经典的有关数据库的书?one question on SQLRe: 如何在existing Access DB中负相同的一个值给一个fiel[转载] foxpro and c#a simple question about insert有没有用过 oracle data warehouse builder