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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-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

Browse pgsql-admin by date

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

Browse pgsql-patches by date

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