Remove diacritic

From: Jiří Němec <konference(at)menea(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Remove diacritic
Date: 2006-12-11 07:43:09
Message-ID: 1227347816.20061211084309@menea.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

Browse pgsql-general by date

  From Date Subject
Next Message Mohan Kumar Thangaraj 2006-12-11 09:48:08 Need some Technical support !!!
Previous Message Jimmy Zhang 2006-12-11 03:54:59 vtd-xml 1.9 released