SQL & PL/SQL

Hi everyone,

I am trying to convert a string with western european character set to US Ascii character set. Idea is to remove all "accent" on top of the "accented characters"

Here is an example .À should be converted to A.

I have tried using the following, but some characters are not converted.

SELECT decompose(to_single_byte('ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßïîíìëêéèçæåäãâáà'))
FROM dual;

The result is :

AAA?A??CEEEEIIII??OOO?O??UUUUY??iiiieeeec??a?aaa

As you can see, 12 characters converted to questions marks, meaning they didnt converted properly like others.

I will appreciate any suggesstions or code example of how people have tried to convert western european character set to US Ascii.

Thanks