Re: From latin9 to sql_ascii??

--- Jaime Casanova <systemguards(at)yahoo(dot)com> escribió:

> --- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> escribió:
>> Jaime Casanova <systemguards(at)yahoo(dot)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.

This page shows the differences between Latin1 &
Latin9:
http://www.cs.tut.fi/~jkorpela/latin9.html

The diffs are:

164: the euro symbol. (sql_ascii = 'E')???
166: an S with a symbol above (sql_ascii = 'S')
168: the same but lower case (sql_ascii = 's')
180: an Z with a symbol above (sql_ascii = 'Z')
184: the same but lower case (sql_ascii = 'z')
188: it's an O merge with an E (sql_ascii = '')???
189: the same but lower case (sql_ascii = '')???
190: an Y with a 2 points above (sql_ascii = 'Y')

Comments?

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