X-Original-To: pgsql-patches-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0A8DB3B6F62 for ; Sat, 18 Dec 2004 04:33:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 09154-05 for ; Sat, 18 Dec 2004 04:33:22 +0000 (GMT) Received: from web50009.mail.yahoo.com (web50009.mail.yahoo.com [206.190.38.24]) by svr1.postgresql.org (Postfix) with SMTP id 3E54B3CC42A for ; Sat, 18 Dec 2004 04:33:19 +0000 (GMT) Received: (qmail 38252 invoked by uid 60001); 18 Dec 2004 04:33:18 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=Qlygxnwwba+sCY1KBq92L0qvezwDMTf8CymxYNhrMhzF60kWZgR3Wbl6l6FIpIB6cU7zJL4YEwgqE1wo6vGwHElS1WWMgFJOpiOtQH55Y29PxaLRitwwhDKOee/lFbLdifkEdGDKAmj2JzT94AsYxof4LNo5VVcsDp3i8JGuFsc= ; Message-ID: <20041218043318.38250.qmail@web50009.mail.yahoo.com> Received: from [200.10.147.71] by web50009.mail.yahoo.com via HTTP; Fri, 17 Dec 2004 22:33:18 CST Date: Fri, 17 Dec 2004 22:33:18 -0600 (CST) From: Jaime Casanova Subject: Re: From latin9 to sql_ascii?? To: pgsql-patches@postgresql.org In-Reply-To: <24173.1103318509@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-104407197-1103344398=:36827" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.298 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200412/163 X-Sequence-Number: 14155 --0-104407197-1103344398=:36827 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Id: Content-Disposition: inline --- Tom Lane escribió: > Jaime Casanova writes: > > 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? > > Works for me. Anyone feel this is too big a change > to push into 8.0? > Strictly speaking it's a new feature, but it sure > looks harmless from here. You guys have the code, you guys have the power. I don't think it can cause any problem. :) > > Personally I'd say that the euro symbol should map > to ' ' not 'E', but am not set on that. > Maybe, someone that uses the euro symbol can comment?? if not, and you said that we can just map that symbol to ' '. Here's the *fixed* patch it's up to you wich one to use. 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 --0-104407197-1103344398=:36827 Content-Type: text/plain; name="ascii2.patch" Content-Description: ascii2.patch Content-Disposition: inline; filename="ascii2.patch" *** src/backend/utils/adt/ascii.c.orig 2004-08-29 00:06:49.000000000 -0500 --- src/backend/utils/adt/ascii.c 2004-12-17 23:02:01.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 + */ + ascii = " cL YS sCa -R Zu .z EeY?AAAAAAACEEEEIIII NOOOOOxOUUUUYTBaaaaaaaceeeeiiii nooooo/ouuuuyty"; + range = RANGE_160; + } else if (enc == PG_WIN1250) { /* --0-104407197-1103344398=:36827--