From: | Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp> |
---|---|
To: | fubjj(at)flashmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Does column header support multibyte character? |
Date: | 2000-12-15 00:59:38 |
Message-ID: | 20001215095938G.t-ishii@sra.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
No. However an encoding "MULE_INTERNAL" would do almost what you want.
MULE_INTERNAL is compatible with EUC_CN and EUC_TW. So you could
create a table having EUC_CN and EUC_TW columns like this.
create table t1(euc_cn text, euc_tw text);
\encoding EUC_CN
insert into t1(euc_cn) values('text in EUC_CN');
\encoding EUC_TW
update t1 set euc_tw = 'text in EUC_CN';
Not so convenience, though.
--
Tatsuo Ishii
From: Dave <fubjj(at)flashmail(dot)com>
Subject: Re: [GENERAL] Does column header support multibyte character?
Date: Thu, 02 Nov 2000 23:49:30 +0800
Message-ID: <vIsBOlMKaxjKf35AkG3dQTmKfxQ5(at)4ax(dot)com>
> Thanks for your reply,
>
> My question is, can I use chinese, say Chinese used in Taiwan (EUC_TW?
> or Big5?), to name columns inside table. Furthermore, is it possible
> to have columns with different encoding within the same table?
>
> Many thanks
> Dave
>
>
>
>
> On Thu, 02 Nov 2000 18:33:01 +0900, you wroth:
>
> >> Can I use chinese as the column header?
> >
> >I'm not sure what kind of chinese encoding you want to use, anyway
> >PostgreSQL supports following encodings:
> >
> >EUC-CN(simplified chinese EUC based on GB2312)
> >EUC-TW(traditional chinese EUC based on CNS 11643-1986)
> >Big5(yet another traditional chinese encoding, only for frontend)
> >
> >Sample files for each encoding are in test/mb/sql.
> >
> >see doc/README.mb for more details also.
From | Date | Subject | |
---|---|---|---|
Next Message | Alvar Freude | 2000-12-15 01:21:58 | Re: Apache+Postgresql (mod_auth_pgsql) |
Previous Message | Robert B. Easter | 2000-12-15 00:29:41 | Re: create trigger (can't compile example, problem with include files) |