--- Jaime Casanova <[EMAIL PROTECTED]> escribi�:
> --- Tom Lane <[EMAIL PROTECTED]> escribi�:
>> Jaime Casanova <[EMAIL PROTECTED]> 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
ascii.patch
Description: ascii.patch
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
