From: | Clemens Schwaighofer <cs(at)tequila(dot)co(dot)jp> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Question for Postgres 8.3 |
Date: | 2008-02-05 02:44:34 |
Message-ID: | 47A7CD92.4010809@tequila.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/05/2008 11:38 AM, Tom Lane wrote:
> Clemens Schwaighofer <cs(at)tequila(dot)co(dot)jp> writes:
>> * Disallow database encodings that are inconsistent with the server's
>> locale setting (Tom)
>
>> does this mean, if my server LOCALE is for example UTF-8.en_US, and I want
>> to create a EUC_JP database it gets rejected? do I missunderstand that?
>
> Nope, you have it correctly.
okay, good, as I finally have a reason to change this then on those view
databases.
>> Normaly my servers have default locale set to UTF-8.en_US but also have the
>> locales for UTF-8.ja_JP and EUC_JP there, 99.9% of my databases are utf-8,
>> but I have some clients that created EUC_JP databases, will the upgrade
>> affect this?
>
> I'm surprised your clients haven't been screaming about bogus sorting
> and upper/lowercasing behavior.
well, originally they were on a server that is also in EUC_JP, but they
need to move away to one of my servers that is pure UTF-8, and I cannot
change this setting because of my other databases, so probably better to
convert them over to UTF-8 and adept the scripts to convert to the
target encoding, rather than going on with the same mess.
> If you want to support multiple encodings, the only safe locale choice
> is (and always has been) C. If you doubt this, troll the archives for
> awhile --- for example, searching for locale+encoding in pgsql-bugs
> should provide plenty of amusing reading matter. 8.3 is just refusing
> to do things that are known to be unsafe in previous releases.
>
> regards, tom lane
--
[ Clemens Schwaighofer -----=====:::::~ ]
[ IT Engineer/Manager, TEQUILA\ Japan IT Group ]
[ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ]
[ Tel: +81-(0)3-3545-7703 Fax: +81-(0)3-3545-7343 ]
[ http://www.tequila.co.jp ]
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Saito | 2008-02-05 02:47:26 | Re: Question for Postgres 8.3 |
Previous Message | Tom Lane | 2008-02-05 02:38:38 | Re: Question for Postgres 8.3 |