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

From Oliver Jowett
Subject Re: SQL_ASCII vs. 7-bit ASCII encodings
Date
Msg-id 4283CE1B.90104@opencloud.com
Whole thread Raw
In response to Re: SQL_ASCII vs. 7-bit ASCII encodings  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: SQL_ASCII vs. 7-bit ASCII encodings  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Best way to scan on-disk bitmaps
Next
From: Robert Treat
Date:
Subject: Re: Views, views, views: Summary of Arguments