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/