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

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-patches by date

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

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