Re: SQL_ASCII vs. 7-bit ASCII encodings

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: SQL_ASCII vs. 7-bit ASCII encodings
Date: 2005-05-12 21:43:55
Message-ID: 4283CE1B.90104@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut wrote:
> Am Donnerstag, 12. Mai 2005 14:57 schrieb Oliver Jowett:
>
>>My 8.0.0 (what I happen to have on hand) initdb creates a SQL_ASCII
>>cluster by default unless I specify -E.
>
>
> Then you use the locale C. We could create a 7-bit encoding and map it to
> locale C, I suppose.

Ok, I think that's what I intended :)

Do we choose SQL_ASCII in any case other than a C locale?

> That would cripple a system that many users are perfectly content with now. I
> compare this to the occasional requests to make pg_hba.conf reject everyone
> by default. We have to err a little on the side of usablity. Anyway, the
> issue here is the mismatch between the C locale and the SQL_ASCII encoding.
> The solution is to fix that mismatch, not cripple the entire system.

Well, I wasn't thinking of using a 7-bit encoding always, just as a
replacement for the cases where we currently choose SQL_ASCII. Does that
sound reasonable?

-O

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Treat 2005-05-12 21:52:43 Re: Views, views, views: Summary of Arguments
Previous Message Tom Lane 2005-05-12 21:40:06 Re: Best way to scan on-disk bitmaps