Diatric string conversion in Oracle – TO_ASCII alternative in Oracle - How to remove accents and special characters

oracle character-encoding plsql ascii non-ascii-characters

Would something like this be suitable? perhaps wrap it in a function?

SELECT CONVERT(TRANSLATE('Ä Ê Í Ó Ø A B C D E ã Ã ã Ã'   ,'ãÃ','aA')   ,'US7ASCII','WE8ISO8859P1') from dual

oracle character-encoding plsql ascii non-ascii-characters

The function below works fine in Oracle for almost all characters in Portuguese language, but it doesn't work for the character ‘ã’ or ‘Ã’

SELECT CONVERT('Ä Ê Í Ó Ø A B C D E ã Ã','US7ASCII','WE8ISO8859P1') from dual

oracle character-encoding plsql ascii non-ascii-characters

Try to use

SELECT CONVERT('Ä Ê Í Ó Ø A B C D E ã Ã', 'us7ascii', 'ee8mswin1250') FROM DUAL

This will remove characters ‘ã’ or ‘Ã’.

CodeHunter