can i use to_ascii function ?
От
j n
Тема
can i use to_ascii function ?
Дата
Msg-id
46f93e0d0702230412i7a576ef9jd85c2823fa2c65e5@mail.gmail.com
Список
Дерево обсуждения
can i use to_ascii function ? "j n" <jneuschld@gmail.com>
Re: can i use to_ascii function ? Michael Fuhr <mike@fuhr.org>
Re: can i use to_ascii function ? Achilleas Mantzios <achill@matrix.gatewaynet.com>
Hi
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 :
SELECT to_ascii('ščďť')
i get an error : ERROR: encoding conversion from UTF8 to ASCII not supported
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 ?
pls help
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 :
SELECT to_ascii('ščďť')
i get an error : ERROR: encoding conversion from UTF8 to ASCII not supported
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 ?
pls help
В списке pgsql-admin по дате отправления