Обсуждение: From latin9 to sql_ascii??

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

Jaime Casanova <systemguards@yahoo.com> writes:
> => select to_ascii('Jim�nez');
> will retrieve 'Jimenez' at least it works on Latin1
> encoding.

> Why it not work on Latin9,

Probably because it hasn't got a table for Latin9.  Feel free to
contribute one --- see src/backend/utils/adt/ascii.c.

            regards, tom lane

 --- Tom Lane <tgl@sss.pgh.pa.us> escribió:
> Jaime Casanova <systemguards@yahoo.com> writes:
> > => select to_ascii('Jiménez');
> > will retrieve 'Jimenez' at least it works on
> Latin1
> > encoding.
>
> > Why it not work on Latin9,
>
> Probably because it hasn't got a table for Latin9.
> Feel free to
> contribute one --- see
> src/backend/utils/adt/ascii.c.
>

I will be pleased of, if i can understand this.
Can you tell me where i can found info about this
issue?

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