Search code examples
sqloracle-databasebi-publisher

Remove accent/special characters in columns in SQL

Is there anyway we can remove the accent in columns?

Example: per_names table has following column names:

Name
Arévalo
Chère

I want this column to have values as follows:

Name
    Arevalo
    Chere

Is this possible ?

Solution

  • You can try using the translate command..

    
TRANSLATE(data,'ÁÉáéÑ','AEaeN')

    That will map: Á to A, É to E, á to a, é to e, Ñ to N. Just keep adding the characters you need to map more