From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | ericpoon(dot)mac(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Help: chinese character set support (EUC_TW to/from |
Date: | 2005-06-17 15:36:19 |
Message-ID: | 20050618.003619.39152020.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Strange. I have successfully set the client encoding to BIG5 with
PostgreSQL 8.0.3 on Linux.
$ psql euc_tw
Welcome to psql 8.0.3, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
euc_tw=# \encoding
EUC_TW
euc_tw=# set client_encoding to 'BIG5';
SET
I suspect you have some problems with your PostgreSQL installation.
--
Tatsuo Ishii
> 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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2005-06-17 16:18:53 | Re: Autovacuum in the backend |
Previous Message | Chris Browne | 2005-06-17 15:30:17 | Re: pgavd status |