Re: SQL_ASCII vs. 7-bit ASCII encodings

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

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.

> > Certainly, making 7-bit ASCII the default encoding
> > is not an option.
>
> Why is that?

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.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2005-05-12 15:00:12 Re: implementing NOTIFY with message parameter
Previous Message Tom Lane 2005-05-12 14:48:50 Re: implementing NOTIFY with message parameter