Skip site navigation (1) Skip section navigation (2)

Default encoding for new databases

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: Default encoding for new databases
Date: 2005-12-08 23:04:26
Message-ID: 200512090004.27144.peter_e@gmx.net (view raw or flat)
Thread:
Lists: pgadmin-hackers
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/

pgadmin-hackers by date

Next:From: Florian G. PflugDate: 2005-12-09 01:14:50
Subject: Re: Schema bug
Previous:From: Peter EisentrautDate: 2005-12-08 23:00:45
Subject: Sort encoding names

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group