Does column header support multibyte character?

Started by Daveover 25 years ago3 messagesgeneral
Jump to latest
#1Dave
fubjj@flashmail.com

Can I use chinese as the column header?

Thanks
Dave

#2Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Dave (#1)
Re: Does column header support multibyte character?

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.
--
Tatsuo Ishii

#3Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Dave (#1)
Re: Does column header support multibyte character?

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@flashmail.com>
Subject: Re: [GENERAL] Does column header support multibyte character?
Date: Thu, 02 Nov 2000 23:49:30 +0800
Message-ID: <vIsBOlMKaxjKf35AkG3dQTmKfxQ5@4ax.com>

Show quoted text

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.