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!

Replace non-english characters function

TomeoDec 16 2013 — edited Dec 16 2013

Hi folks,

I have a text which includes non english characters. Is there any trick, how can I replace those characters with "closest" english character?

Examples:

"Hytölä" to become "Hytola"

"Säynatsälo" to become "Säynatsälo"

etc ...

I was thinking about usage of REGEXP

select regexp_replace('Hytölä Säynatsälo ', '[^0-9A-Za-z]', '') from dual

but a pattern is not correct.

Any suggesitons?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 13 2014

Added on Dec 16 2013

2 comments

1,255 views