Character Set Translation

Database
Teradata Employee

Character Set Translation

I want to convert latin characters to English. E.g. PAÑO ESPONJA to PANO ESPONJA. Is there a way to do this using the teradata TRANSLATE function?
Thanks!
1 REPLY
Senior Apprentice

Re: Character Set Translation

You can't use TRANSLATE for that purpose, but the Oracle Translate UDF (OTRANSLATE) might be what you're looking for.

Dieter