From latin9 to sql_ascii??

From: Jaime Casanova <systemguards(at)yahoo(dot)com>
To: admin pgsql <pgsql-admin(at)postgresql(dot)org>
Subject: From latin9 to sql_ascii??
Date: 2004-12-13 19:43:16
Message-ID: 20041213194316.77144.qmail@web50009.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-patches

Hi,

someone show me that if had accents in a word i can
suppress it with the to_ascii function.

=> select to_ascii('Jiménez');

will retrieve 'Jimenez' at least it works on Latin1
encoding.

Why it not work on Latin9, there's another way of
doing such a thing?

regards,
Jaime Casanova

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Marek Lewczuk 2004-12-13 20:10:13 plperl loading
Previous Message Jeff 2004-12-13 19:24:46 preventing the effective fork bomb when restarting a high traffic server?

Browse pgsql-patches by date

  From Date Subject
Next Message Guillaume LELARGE 2004-12-13 21:27:40 Updates for french .po files
Previous Message Peter Eisentraut 2004-12-13 16:30:49 Re: New Korean client messages po files