--- 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