pgadmin3 proposes UTF8 as the default for new databases. While this is undoubtedly a contribution to world peace, it's also an invitation to create broken databases. The default encoding should be the encoding of template1 (or alternatively the template database chosen by the user) so that it matches the initialized locale. This is how the command line works. Other combinations will lead to databases with unusable sorting behavior. Please correct that.
-- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
