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