From: Jaime Casanova <systemguards@yahoo.com>
To: pgsql-patches@postgresql.org
Subject: Re: From latin9 to sql_ascii??
Date: Fri, 17 Dec 2004 15:03:27 -0600 (CST)
Message-ID: <20041217210327.73063.qmail@web50006.mail.yahoo.com> (raw)
In-Reply-To: <20041214212629.54457.qmail@web50008.mail.yahoo.com>
--- 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.comAttachments:ascii.patch (application/octet-stream, 612B) download
*** src/backend/utils/adt/ascii.c.orig 2004-12-17 15:16:29.000000000 -0500
--- src/backend/utils/adt/ascii.c 2004-12-17 15:18:29.000000000 -0500
***************
*** 53,58 ****
--- 53,66 ----
ascii = " A L LS \"SSTZ-ZZ a,l'ls ,sstz\"zzRAAAALCCCEEEEIIDDNNOOOOxRUUUUYTBraaaalccceeeeiiddnnoooo/ruuuuyt.";
range = RANGE_160;
}
+ else if (enc == PG_LATIN9)+ {+ /*+ * ISO-8859-15 <range: 160 -- 255>+ */+ ascii = " cLEYS sCa -R Zu .z EeY?AAAAAAACEEEEIIII NOOOOOxOUUUUYTBaaaaaaaceeeeiiii nooooo/ouuuuyty";+ range = RANGE_160;+ }
else if (enc == PG_WIN1250)
{
/*
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: systemguards@yahoo.com, pgsql-patches@postgresql.org
Subject: Re: From latin9 to sql_ascii??
In-Reply-To: <20041217210327.73063.qmail@web50006.mail.yahoo.com>
References: <20041214212629.54457.qmail@web50008.mail.yahoo.com> <20041217210327.73063.qmail@web50006.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox