Search Postgresql Archives

Help: chinese character set support (EUC_TW to/from BIG5 conversion)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux