| From: | "eblues" <ericpoon(dot)mac(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Help: chinese character set support (EUC_TW to/from BIG5 conversion) |
| Date: | 2005-06-16 15:14:16 |
| Message-ID: | 1118934856.377137.309310@g49g2000cwa.googlegroups.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hans-Jürgen Schönig | 2005-06-16 15:29:47 | Re: Autovacuum in the backend |
| Previous Message | Alvaro Herrera | 2005-06-16 15:11:20 | Re: Autovacuum in the backend |