Help: chinese character set support (EUC_TW to/from BIG5 conversion) - Mailing list pgsql-general

From eblues
Subject Help: chinese character set support (EUC_TW to/from BIG5 conversion)
Date
Msg-id 1118934856.377137.309310@g49g2000cwa.googlegroups.com
Whole thread Raw
Responses Re: Help: chinese character set support (EUC_TW to/from BIG5 conversion)
Re: Help: chinese character set support (EUC_TW to/from
List pgsql-general
1. Would like to try if you've ever successfully put Chinese characters
into the so-called "Postgresql" databases. Their four support
communities appear non-asian so far.

2. My problems is, although the 8.0 documentation (ch.14 pg. 292)
claims the conversion between EUC_TW and BIG5 is avalible, an actual
error message reveals it 's not supported, see below command and error
message:

代碼:

hongkong=# set client_encoding to 'BIG5';
ERROR:  conversion between BIG5 and EUC_TW is not supported


Am I missing something?


3. Below lists the server_encoding is EUC_TW (the only Traditional
Chinese it supports on the server side):

代碼:

hongkong=# \l
        List of databases
   Name    |  Owner   | Encoding
-----------+----------+-----------
 hongkong  | postgres | EUC_TW



4. fyi, sorry to dump you guy an "show all" screen (selected output):

代碼:

hongkong=# show all
hongkong-# ;
              name              |                       setting

-----------------------------------------------------------------------------------

......
 lc_collate                     | C
 lc_ctype                       | C
 lc_messages                    | C
 lc_monetary                    | C
 lc_numeric                     | C
 lc_time                        | C
....
 syslog_facility                | LOCAL0
 syslog_ident                   | postgres
 TimeZone                       | Hongkong
 ..
(139 rows)


cheers, thanks in advance.


pgsql-general by date:

Previous
From: stig erikson
Date:
Subject: Re: psql: FATAL: database "template1" is not currently accepting
Next
From: rasdj@frontiernet.net
Date:
Subject: Multiple COPYs