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!

How can I change extended latin characters to their unaccented ASCII equivalents?

scott_hJul 24 2014 — edited Aug 17 2014

I am trying to do this without mapping all of the possible solutions.

  •   é becomes e
  •   ê becomes e
  •   á becomes a
  •   ç becomes c
  •   Ď becomes D

This question was asked here with a Perl tag:

regex - How can I change extended latin characters to their unaccented ASCII equivalents? - Stack Overflow

Has anyone accomplished similar without mapping each possible combination?

RDBMS : 11.2.0.3.0

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2014
Added on Jul 24 2014
7 comments
2,841 views