Re: Fwd: convert(USING utf8_to_iso_8859_15) on Windows

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Pierre Thibaudeau <pierdeux(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Fwd: convert(USING utf8_to_iso_8859_15) on Windows
Date: 2007-02-06 08:11:55
Message-ID: 20070206081154.GA27851@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jan 29, 2007 at 03:46:34PM -0500, Pierre Thibaudeau wrote:
> * Windows XP does support UTF8, yet it is not possible (as far as I
> know) to define one's locale to have anything to do with UTF8
> (presumably in the sense that UTF8 isn't an aspect of a specific
> locale): there is no en_US.UTF8 or fr_CA.UTF8 locales, for instance.
> But why should this matter? Say I am entering the data through a
> piece of software that works with UTF8, via the ODBC driver. Say
> again that I output the data with another software that expects UTF8,
> via the JDBC driver. Why does it matter that my system should be
> localized in another encoding?

Because postgresql relies on OS support to do things like string
comparison. Since Windows does not support UTF-8 locales, sorting there
with UTF-8 is a bit of a hack, whereas many (some?) Unixes can handle
it natively.

At some point postgresql will know how to do string comparisons itself
ad thus the problem will be solved, but it hasn't happened yet.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2007-02-06 09:21:54 Re: Locking question?
Previous Message Gurjeet Singh 2007-02-06 07:20:24 Re: Alter definition of a column