0

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 ?

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
  • 1
    Does this answer your question? [Remove accents from string in Oracle](https://stackoverflow.com/questions/53019511/remove-accents-from-string-in-oracle) –  Apr 18 '22 at 15:53

1 Answers1

1

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

Pugzly
  • 844
  • 3
  • 14