--- Jaime Casanova <systemguards@yahoo.com> escribió:
> --- 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.
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