Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

remove diacritics characters from string

user13117585Mar 17 2011 — edited Mar 17 2011
Hi guys,

Look at the following examples:
SELECT TRANSLATE('äàáâãăāåąæčçðďéèëêěĕėęğģġîĭïīìíłļľŀñńňņöóòôõσøřśŝšşţüúùûǔųūůŵýÿżźžżαβßγδεζŋηικλμµνξπρσςτυφω',
        'äàáâãăāåąæčçðďéèëêěĕėęğģġîĭïīìíłļľŀñńňņöóòôõσøřśŝšşţüúùûǔųūůŵýÿżźžżαβßγδεζŋηικλμµνξπρσςτυφω',
        'aaaaaaaaaaccddeeeeeeeegggiiiiiillllnnnnooooooorsssstuuuuuuuuwyyzzzzassydeznniklmmnxprsstufo'
      )
      FROM DUAL;
Is there any way I can do it automaticaly without having to do that translate ?

Thanks for your help,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2011
Added on Mar 17 2011
10 comments
2,222 views