Re: Question for Postgres 8.3 - Mailing list pgsql-general

From Hiroshi Saito
Subject Re: Question for Postgres 8.3
Date
Msg-id 09a601c867a1$71155c40$0301a8c0@HP22720319231
Whole thread Raw
In response to Question for Postgres 8.3  (Clemens Schwaighofer <cs@tequila.co.jp>)
List pgsql-general
Hi.

----- Original Message -----
From: "Clemens Schwaighofer" <cs@tequila.co.jp>


> hi,
>
> on the page: <http://www.postgresql.org/docs/8.3/static/release-8-3.html>
>
> in point E.1.2.3:
>
> * 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?
>
> 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?

When using server encoding for EUC_JP and UTF-8 simultaneously, it is not allowed
except LOCALE=C. Moreover, it can also use SQL_ASCII satisfactory natural.
please initdb --no-locale.

Regards,
Hiroshi Saito


pgsql-general by date:

Previous
From: Clemens Schwaighofer
Date:
Subject: Re: Question for Postgres 8.3
Next
From: "bh yuan"
Date:
Subject: question about PANIC: hash table "Shared Buffer Lookup Table" corrupted