Thread: Remove diacritic

Remove diacritic

From
Jiří Němec
Date:
Good morning,

I would like to remove diacritic from string like 'žluťoučký kůň'
(UTF-8) and transform it into 'zlutoucky kun'. I have used function
convert(); and SQL_ASCII as destination encoding.

Converted string still contains diacritic:

SELECT convert('žluťoučký kůň','UTF8','SQL_ASCII')

array(1) {
["convert"]=>
string(19) "žluťoučký kůň"
}

Thanks for your help.

--
Jiri Nemec
http://www.menea.cz/