From: Bryan Wu <lfwu@yahoo.com>
Subject: Urgent Question on Postgresql
Date: Sun, 18 Mar 2001 04:39:36 -0800 (PST)
Message-ID: <20010318123936.79559.qmail@web10003.mail.yahoo.com>
> Hi tatsuo Ishii,
>
> I learn from postgresql mailing list that you are
> concerning the problem the UTF8 support in Postgresql.
> Currently I want to choose a database to store chinese
> (BIG5 and GB) information. Could you tell me if the
> Postgresql can store information in UTF-8 format. I
> think it is better for me to use UTF-8 since I need to
> handle the Big5 and GB at the same time.
Yes.
> I find very little information on how to configure the
> postgresql to use default encoding UTF-8 when storing
> data. Do you have any idea?
Enable the multibyte capability(configure --enable-multibyte) and
do createdb -E UNICODE.
> And do you know if postgresql has any import tools so
> I can import some chinese information directly to the
> tables?
PostgreSQL 7.1 will be able to do an automatic conversion between
UTF-8 and Big5 or EUC-CN(GB). Here is a sample:
createdb -E UNICODE unicode
psql unicode
\encoding BIG5
insert into big_table values('some big5 data');
\encoding EUC_CN
insert into gb_table values('some EUC_CN data');
:
:
--
Tatsuo Ishii
