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

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


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

Attachment: ascii.patch
Description: ascii.patch

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?


Reply via email to