Skip site navigation (1) Skip section navigation (2)

can i use to_ascii function ?

From: "j n" <jneuschld(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: can i use to_ascii function ?
Date: 2007-02-23 12:12:53
Message-ID: 46f93e0d0702230412i7a576ef9jd85c2823fa2c65e5@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Achilleas MantziosDate: 2007-02-23 12:39:24
Subject: Re: can i use to_ascii function ?
Previous:From: Vishal AroraDate: 2007-02-23 10:58:43
Subject: Data Restore from WAL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group