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 D4EEE3CC2F2 for ; Fri, 17 Dec 2004 21:03:32 +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 64467-01 for ; Fri, 17 Dec 2004 21:03:27 +0000 (GMT) Received: from web50006.mail.yahoo.com (web50006.mail.yahoo.com [206.190.38.21]) by svr1.postgresql.org (Postfix) with SMTP id 99D443CC1B8 for ; Fri, 17 Dec 2004 21:03:27 +0000 (GMT) Received: (qmail 73069 invoked by uid 60001); 17 Dec 2004 21:03:27 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=RFeGTgvDzkg3d8LoYfw6NFDucGwgpASSKaaA+6YNGwQjL1fu7JoEyfkx9vYxGW2XuzbVnSKOg3nM3h57wCEnh4Y+9yxQW/AwlStnKcu/wAjEnzcL91mEc8wDPdeJtBmihnH2fkn6kXtggHSQE3nx79wRxgfo0g1Li2CBOsg7jl0= ; Message-ID: <20041217210327.73063.qmail@web50006.mail.yahoo.com> Received: from [200.93.192.139] by web50006.mail.yahoo.com via HTTP; Fri, 17 Dec 2004 15:03:27 CST Date: Fri, 17 Dec 2004 15:03:27 -0600 (CST) From: Jaime Casanova Subject: Re: From latin9 to sql_ascii?? To: pgsql-patches@postgresql.org In-Reply-To: <20041214212629.54457.qmail@web50008.mail.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="0-1711209948-1103317407=:73030" Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.329 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200412/157 X-Sequence-Number: 14149 --0-1711209948-1103317407=:73030 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Content-Id: Content-Disposition: inline --- Jaime Casanova escribió: > --- Tom Lane escribió: >> Jaime Casanova 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 --0-1711209948-1103317407=:73030 Content-Type: application/octet-stream; name="ascii.patch" Content-Transfer-Encoding: base64 Content-Description: ascii.patch Content-Disposition: attachment; filename="ascii.patch" KioqIHNyYy9iYWNrZW5kL3V0aWxzL2FkdC9hc2NpaS5jLm9yaWcJMjAwNC0x Mi0xNyAxNToxNjoyOS4wMDAwMDAwMDAgLTA1MDAKLS0tIHNyYy9iYWNrZW5k L3V0aWxzL2FkdC9hc2NpaS5jCTIwMDQtMTItMTcgMTU6MTg6MjkuMDAwMDAw MDAwIC0wNTAwCioqKioqKioqKioqKioqKgoqKiogNTMsNTggKioqKgotLS0g NTMsNjYgLS0tLQogIAkJYXNjaWkgPSAiIEEgTCBMUyBcIlNTVFotWlogYSxs J2xzICxzc3R6XCJ6elJBQUFBTENDQ0VFRUVJSURETk5PT09PeFJVVVVVWVRC cmFhYWFsY2NjZWVlZWlpZGRubm9vb28vcnV1dXV5dC4iOwogIAkJcmFuZ2Ug PSBSQU5HRV8xNjA7CiAgCX0KKyAgCWVsc2UgaWYgKGVuYyA9PSBQR19MQVRJ TjkpCisgIAl7CisgIAkJLyoKKyAgCQkgKiBJU08tODg1OS0xNSA8cmFuZ2U6 IDE2MCAtLSAyNTU+CisgIAkJICovCisgIAkJYXNjaWkgPSAiICBjTEVZUyBz Q2EgIC1SICAgICBadSAueiAgIEVlWT9BQUFBQUFBQ0VFRUVJSUlJIE5PT09P T3hPVVVVVVlUQmFhYWFhYWFjZWVlZWlpaWkgbm9vb29vL291dXV1eXR5IjsK KyAgCQlyYW5nZSA9IFJBTkdFXzE2MDsKKyAJfQogIAllbHNlIGlmIChlbmMg PT0gUEdfV0lOMTI1MCkKICAJewogIAkJLyoK --0-1711209948-1103317407=:73030--