From: Iain <iain@mst.co.jp>
To: pgsql-docs@postgresql.org
Subject: Encoding and multibye support
Date: Wed, 28 Jan 2004 11:18:53 +0900
Message-ID: <003501c3e545$13858f10$7201a8c0@mst1x5r347kymb> (raw)
Hi All,
I recently had a sight problem with a development database because I used
the default encoding of SQL_ASCII. When I tried to load the database into a
EUC_JP database of course there were some problems with invlaid EUC_JP
characters. Fortunately they were easy to find and fix.
Anyway, my search on "encoding" or "multibyte" showed up nothing in the 7.4
documentation. Eventually I found a page written by Tatsuo Ishii in the 7.2
documentation.
I think that it's an important area, and is a potential trap for new players
so I'd like to see the documentation updated.
The following came out of a discussion with Tom Lane. I submitted it as
comment in the interactive documentation. I think it would be a good idea to
check the details and update the doc:
------
The default encoding SQL_ASCII effectively disables any encoding conversion.
This means that your db will accept any kind of data. It's a potential
problem as you may end up wth different kinds of encoding being used in both
your data and metadata.
It would seem that unless you specifically require to store data in various
encodings then you should select a specific encoding when creating a new
database. Use initdb -E to set the default for all new DBs. This can be
overridden when using creating a new DB
------
Also, the documentation for installation (chapter 14), creating database
clusters (16.2) and creating databases (18.2) doesn't mention encoding at
all. Maybe they should. Also 16.2 should link to the documention for initdb
(Server Applications, section III). I think that wuld be a good idea.
regards
Iain
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-docs@postgresql.org
Cc: iain@mst.co.jp
Subject: Re: Encoding and multibye support
In-Reply-To: <003501c3e545$13858f10$7201a8c0@mst1x5r347kymb>
References: <003501c3e545$13858f10$7201a8c0@mst1x5r347kymb>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox