Re: [HACKERS] Problems in 6.5.3 with Multi-Byte encoding - Mailing list pgsql-bugs

From Tatsuo Ishii
Subject Re: [HACKERS] Problems in 6.5.3 with Multi-Byte encoding
Date
Msg-id 19991130134327B.t-ishii@sra.co.jp
Whole thread Raw
In response to Re: [HACKERS] Problems in 6.5.3 with Multi-Byte encoding  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
> Anyone want to comment on this?  BIG5 anyone?
>
> > With PostgreSQL compiled with support for locales and multi-byte encoding:
> >
> > initdb -e BIG5
> >
> > [start postmaster]
> > psql template1
> > \dS causes a segmentation fault in the backend

The answer is:

You should not do initdb with BIG5, instead you could do:

initdb -e EUC_TW

BIG5 and EUC_TW are both for traditional Chinese, only EUC_TW can be
used for the proffered encoding for the backend, however. In the
setting above, you could use EUC_TW for the frontend side and BIG5 as
well. To use BIG5 in the fronend, you set the environment variable
PGCLIENTENCODING to "BIG5" if you use psql or applications those are
using libpq. In this case, an automatic code conversion between BIG5
and EUC_TW will be performed in the backend.

I'll add the code to prevent BIG5 for initdb -e in the next release.
--
Tatsuo Ishii



pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Problems in 6.5.3 with Multi-Byte encoding
Next
From: Jason Cox
Date:
Subject: problem with v6.5.2