|
|
|
|
|
|
|
|
|
|
Re: How to identify Unicode Characters [message #412413 is a reply to message #412407] |
Thu, 09 July 2009 04:00   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
I don't think it is very efficient to ask what characters are suppored by SQL Server, and how to use a functionon on SQL Server to figure out which characters are supported in an ORACLE forum.
|
|
|
|
Re: How to identify Unicode Characters [message #412445 is a reply to message #412442] |
Thu, 09 July 2009 07:10   |
 |
Michel Cadot
Messages: 68770 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
SQL> with
2 data as (select 'aéñàueoüûç' val from dual),
3 forbidden_chars as (
4 select substr(replace(sys_connect_by_path(chr(127+level),' '),' ',''),2) chars
5 from dual
6 where level = 128
7 connect by level <= 128
8 )
9 select val, translate(val,'a'||chars,'a') new_val
10 from data, forbidden_chars
11 /
VAL NEW_VAL
---------- ----------
aéñàueoüûç aueo
1 row selected.
Regards
Michel
|
|
|
|
|
|
|
|
|
|
Re: How to identify Unicode Characters [message #412648 is a reply to message #412647] |
Fri, 10 July 2009 05:37  |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
The problem is, your definition of what you claim are "special characters" changes from post to post.
First you say "everything except ASCII Characters", and then refuse the solution to that.
Then you say "Everything with an ASCII CODE higher than 127", and then refuse the solution to that.
So make up your mind about what "Special Characters" are first.
And when you now say "Any Character not accepted by SQL SERVER", then I alrady told you it is not really effective to ask that Question in an ORACLE forum.
[Updated on: Fri, 10 July 2009 05:48] Report message to a moderator
|
|
|