Craig Ringer <craig@2ndquadrant.com> writes:
> What we SHOULD be doing is making it an explicit decision to use
> SQL_ASCII, and NEVER creating a cluster or database with that encoding
> by default. Ever. If we can't decide what the correct default encoding
> is (say, if locale is "C") we should error out unless a specific flag is
> set.
There's a large undercurrent of "I say it's bad for you" in this thread,
with frankly nothing to back it up. If we try to be as nanny-ish as
you're suggesting here, we'll just annoy users.
And just to push back on the specific point: SQL_ASCII *is* the correct
default encoding for C locale. Both are agnostic about the meaning of
anything outside the 7-bit ASCII set, while not rejecting such data.
regards, tom lane