t*********i
发帖数: 217 | 1 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! | i****a
发帖数: 36252 | 2 can you so something like
update tbl
set col = replace(col, '¿', '') | t*********i
发帖数: 217 | 3 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****a
发帖数: 36252 | 4 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?
| j*****n
发帖数: 1781 | 5 good point!
see here for printable ASCII range.
【在 i****a 的大作中提到】
: what about, instead of removing this one special character, try removing
: anything that's not in the printable ASCII range?
:
: such
: several
: ,
| t*********i
发帖数: 217 | 6 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 | i****a
发帖数: 36252 | 7 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
| t*********i
发帖数: 217 | 8 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
|
|
