Re: SQL_ASCII vs. 7-bit ASCII encodings - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: SQL_ASCII vs. 7-bit ASCII encodings
Date
Msg-id 200505121655.01347.peter_e@gmx.net
Whole thread Raw
In response to Re: SQL_ASCII vs. 7-bit ASCII encodings  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: SQL_ASCII vs. 7-bit ASCII encodings
List 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/


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: implementing NOTIFY with message parameter
Next
From: Alvaro Herrera
Date:
Subject: Re: implementing NOTIFY with message parameter