Re: Please change default characterset for database cluster - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Please change default characterset for database cluster
Date
Msg-id 20070930202737.GA21046@svana.org
Whole thread Raw
In response to Re: Please change default characterset for database cluster  ("CN" <cnliou9@fastmail.fm>)
List pgsql-general
On Sun, Sep 30, 2007 at 11:55:00AM +0800, CN wrote:
> Various people have various perceptions. I don't feel that my suggestion
> only serves to make PostgreSQL become a software product fitting only
> *myself*. On the contrary, I believe PostgreSQL will become suitable for
> more novice users if initdb will use UNICODE as the default characterset
> when it is not given option "-E" and when it can not correctly derive a
> characterset from locale.

At the end of the day the problem is incompatability between locale and
encoding. If the webmaster can't get the encoding right then they sure
as hell arn't going to get the locale right. And mismatched
encoding/locale will give you even worse problems.

It is a problem with postgres that it relies on the OS for these
things. Patches have been floated over the years and rejected for all
sorts of reasons. Maybe somebody it will get fixed.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Anton Andreev
Date:
Subject: Re: Please change default characterset for database cluster
Next
From: Terry Yapt
Date:
Subject: windows and pg 8.2 (change database to another server)