pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jaime Casanova <systemguards@yahoo.com>
To: pgsql-patches@postgresql.org
Subject: Re: From latin9 to sql_ascii??
Date: Fri, 17 Dec 2004 22:33:18 -0600 (CST)
Message-ID: <20041218043318.38250.qmail@web50009.mail.yahoo.com> (raw)
In-Reply-To: <24173.1103318509@sss.pgh.pa.us>

 --- Tom Lane <tgl@sss.pgh.pa.us> escribió: 
> Jaime Casanova <systemguards@yahoo.com> 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

Attachments:

ascii2.patch (text/plain, 604B) download *** 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 <range: 160 -- 255> + */ + ascii = " cL YS sCa -R Zu .z EeY?AAAAAAACEEEEIIII NOOOOOxOUUUUYTBaaaaaaaceeeeiiii nooooo/ouuuuyty"; + range = RANGE_160; + } else if (enc == PG_WIN1250) { /*

view thread (11+ messages)  latest in thread

Message-ID: <20041218043318.38250.qmail@web50009.mail.yahoo.com>
Permalink:  ../20041218043318.38250.qmail@web50009.mail.yahoo.com/
Also on:    postgresql.org/message-id/20041218043318.38250.qmail@web50009.mail.yahoo.com

 ·  · 

reply

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: <20041218043318.38250.qmail@web50009.mail.yahoo.com>
  References: <24173.1103318509@sss.pgh.pa.us> <20041218043318.38250.qmail@web50009.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