pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jaime Casanova <systemguards@yahoo.com>
Cc: pgsql-patches@postgresql.org
Subject: Re: From latin9 to sql_ascii??
Date: Fri, 17 Dec 2004 16:21:49 -0500
Message-ID: <24173.1103318509@sss.pgh.pa.us> (raw)
In-Reply-To: <20041217210327.73063.qmail@web50006.mail.yahoo.com>
References: <20041217210327.73063.qmail@web50006.mail.yahoo.com>

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.

Personally I'd say that the euro symbol should map to ' ' not 'E',
but am not set on that.

			regards, tom lane



view thread (11+ messages)  latest in thread

Message-ID: <24173.1103318509@sss.pgh.pa.us>
Permalink:  ../24173.1103318509@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/24173.1103318509@sss.pgh.pa.us

 · 

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: tgl@sss.pgh.pa.us, systemguards@yahoo.com, pgsql-patches@postgresql.org
  Subject: Re: From latin9 to sql_ascii??
  In-Reply-To: <24173.1103318509@sss.pgh.pa.us>
  References: <20041217210327.73063.qmail@web50006.mail.yahoo.com> <24173.1103318509@sss.pgh.pa.us>

* 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