Bug#465603: postgresql-8.3: Change default encoding from sql_ascii to UTF8
Joost Kraaijeveld
Version: 8.3~rc2-1+b1
Severity: important
Apparantly the default encoding for the database cluster is sql_ascii, maybe
depending on environmental settings during installation (with aptitude).
Please make it configurable during installation, or choose a wiser default, in
which case UTF8 comes to mind (which is used in the Windows version also
I seem to recall).
-- System Information:
Debian Release: lenny/sid
APT prefers testing
APT policy: (500, 'testing'), (500, 'stable')
Architecture: amd64 (x86_64)
Kernel: Linux 2.6.22-3-amd64 (SMP w/2 CPU cores)
Locale: LANG=C, LC_CTYPE=C (charmap=ANSI_X3.4-1968)
Shell: /bin/sh linked to /bin/bash
Versions of packages postgresql-8.3 depends on:
ii libc6 2.7-6 GNU C Library: Shared libraries
ii libcomerr2 1.40.5-2 common error description library
ii libkrb53 1.6.dfsg.3~beta1-2 MIT Kerberos runtime libraries
ii libldap-2.4-2 2.4.7-4 OpenLDAP libraries
ii libpam0g 0.99.7.1-5 Pluggable Authentication Modules l
ii libpq5 8.3~rc2-1+b1 PostgreSQL C client library
ii libssl0.9.8 0.9.8g-4 SSL shared libraries
ii libxml2 2.6.31.dfsg-1 GNOME XML library
ii postgresql-client-8.3 8.3~rc2-1+b1 front-end programs for PostgreSQL
ii postgresql-common 83 PostgreSQL database-cluster manage
ii tzdata 2007k-2 time zone and daylight-saving time
postgresql-8.3 recommends no packages.
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listm...@lists.debian.org
Peter Eisentraut
> Apparantly the default encoding for the database cluster is sql_ascii,
> maybe depending on environmental settings during installation (with
> aptitude). Please make it configurable during installation, or choose a
> wiser default, in which case UTF8 comes to mind (which is used in the
> Windows version also I seem to recall).
The default encoding is set from the locale, and the default locale is
whatever your system's locale is. (You would get SQL_ASCII if your locale is
C.) If you don't like the result, it is perfectly acceptable to drop the
created cluster and create a new one with the settings of your choice.
Joost Kraaijeveld
On Wed, 2008-02-13 at 18:56 +0100, Peter Eisentraut wrote:
> Am Mittwoch, 13. Februar 2008 schrieb Joost Kraaijeveld:
> > Apparantly the default encoding for the database cluster is sql_ascii,
> > maybe depending on environmental settings during installation (with
> > aptitude). Please make it configurable during installation, or choose a
> > wiser default, in which case UTF8 comes to mind (which is used in the
> > Windows version also I seem to recall).
>
> The default encoding is set from the locale, and the default locale is
> whatever your system's locale is. (You would get SQL_ASCII if your locale is
> C.) If you don't like the result, it is perfectly acceptable to drop the
> created cluster and create a new one with the settings of your choice.
or done automatically with a more sensible default.
Joost
Peter Eisentraut
> That is what I did, but I think it should be (preferably) configurable
> or done automatically with a more sensible default.
The encoding is a direct consequence of the locale. The default locales in
Debian use UTF-8. If you made a different choice upon installation, you
obviously had something specific in mind. So that is honoured. I don't
understand what you expect here. You get what you ask for.