Craig Ringer <cr...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers