[Once again, please copy the mailing list on replies so others can
participate in and learn from the discussion. Also, pgsql-general
might be a more appropriate list than pgsql-admin.]
On Mon, Feb 26, 2007 at 10:53:48AM +0100, j n wrote:
> 1. At first i tried use to_ascii ... convert
> it work
[Please reply to the mailing list so others can participate in and
learn from the discussion.]
On Sat, Feb 24, 2007 at 10:41:51AM +0100, j n wrote:
> maybe one more suggestion ...
> this type
>
> to_ascii(convert(lastname, 'LATIN2'), 'LATIN2')
>
> was not working fine unless i use ./configure -
On Fri, Feb 23, 2007 at 01:12:53PM +0100, j n wrote:
> i need to get rid of acute, and other special symbols from letters. Is any
> way how to do it easy in postgres ?
This has come up before; here's a recent response with suggestions:
http://archives.postgresql.org/pgsql-general/2007-01/msg00702
Στις Παρασκευή 23 Φεβρουάριος 2007 14:12, ο/η j n έγραψε:
> 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
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 ASCI