i need to get rid of acute, and other special symbols from letters. Is any
way how to do it easy in postgres ?
i need conversion like this from slovak language ... :
é, ě -> e
á, ä -> a
š -> s
i tried :
i get an error : ERROR: encoding conversion from UTF8 to ASCII not
that i found something like this
SELECT convert('ščďť', 'UTF8', 'LATIN1')
i get an error : ERROR: character 0xc5a1 of encoding "UTF8" has no
equivalent in "LATIN1"
Is any way how to do it ?
If there is not build in support for this conversion can i create my own ?
pgsql-admin by date
|Next:||From: Achilleas Mantzios||Date: 2007-02-23 12:39:24|
|Subject: Re: can i use to_ascii function ?|
|Previous:||From: Vishal Arora||Date: 2007-02-23 10:58:43|
|Subject: Data Restore from WAL|