Remove the accents

[mfaqueiroz]

Hey,
I'm importing one table that for default cames with letters with accents( "´" "^" "~" as for exemple "á" "ê" "ã" .
There is any quick way to clean the accents?

(e.g. converts Olá --to--> Ola)

Thank you

 

[arnelgp]

use replace function:

update table set field1 = replace(replace(replace(field1,"á","a"), "ã", "a"), "ê", "e")

 

[mfaqueiroz]

thanks!! !

I also want to replace the "'" from the words to blank spaces,

I've write the follow code:

update table set field1 = replace(field1,''','')

but appears always the invalid syntax error...
do you have any idea what i'm doing wrong?

thank you!

 

[arnelgp]

update table set field1 = replace(field1,"'", ""')

 

[mfaqueiroz]

don't accpet the " :/ that way i have put ' , it worked with the acents exemple...