Skip site navigation (1) Skip section navigation (2)

Re: From latin9 to sql_ascii??

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>,Jaime Casanova <systemguards(at)yahoo(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: From latin9 to sql_ascii??
Date: 2004-12-18 04:57:54
Message-ID: 27840.1103345874@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-patches
Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> writes:
> On Fri, Dec 17, 2004 at 11:09:17PM +0100, Peter Eisentraut wrote:
>> 'OE' and 'oe', most likely, but someone more familiar with French 
>> typography might correct me.

> OE and oe would be correct, but we can't do that with the current code.

More to the point, there are no such characters in 7-bit ASCII.

I think Alvaro might be suggesting that to_ascii() should expand these
to the two-character sequences "OE" and "oe", but ISTM that opens a can
of worms better left sealed.  There are a *lot* of characters that have
translations of differing levels of plausibility into ASCII.  I'm okay
with dropping accent marks but I'm not sure about doing more than that.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: gayatri ganpaaDate: 2004-12-18 20:30:09
Subject: Problem with JDBC
Previous:From: Jaime CasanovaDate: 2004-12-18 04:33:18
Subject: Re: From latin9 to sql_ascii??

pgsql-patches by date

Next:From: Tom LaneDate: 2004-12-18 19:31:15
Subject: Proposed patch for psql backtick safety
Previous:From: Jaime CasanovaDate: 2004-12-18 04:33:18
Subject: Re: From latin9 to sql_ascii??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group