Does postgresql support HKSCS ?

Eric Tan wrote:

Hi all,

I would like to setup a database which can accept HKSCS - "Hong
Kong Supplementary Character Set". Here is the reference:
http://www.info.gov.hk/digital21/eng/hkscs/introduction.html

Can somebody tell me how to do it? I've try database encoding with
EUC_TW, SQL_ASCII and UNICODE, all failed.

These are my configure: RH9 + Postgresql 7.3.4 + Tomcat 4.1.24 +
JSP. Do I need to update RH9 also?

Looking forward for you reply. Thank you very much.

Best Regards,
Eric Tan

?u?V???? ?V?k???v??? VoiceMail ?w???....
http://voicemail.yahoo.com.hk
<http://hk.yahoo.com/mail_tagline/?http://hk.voicemail.yahoo.com/&gt;

Isn't HKSC one of the languages supported by UNICODE? I thought they had
every langauge past and present in it.

--
"You are behaving like a man",
is an insult from some women,
a compliment from an good woman.

Dennis Gearon wrote:

Isn't HKSC one of the languages supported by UNICODE? I thought they had
every langauge past and present in it.

You'll have to map HKSCS to UNICODE yourself before the data hits
postgresql, and data out of postgresql would be in UNICODE, and up to
you to convert back to HKSCS after retrival. pgsql doesn't have *native*
HKSCS support.

HKSCS is an extension of Big5 right? From the info we have:

http://www.unicode.org/faq/unicode_iso.html
http://www.info.gov.hk/digital21/eng/hkscs/download/big5-iso.txt

We might be able to duplicate Big5's code in pgsql to support HKSCS
natively.

I don't have experience with HKSCS nor test materials to attempt it though.

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
4:00pm up 287 days, 7:33, 8 users, load average: 6.32, 6.34, 6.18

Hi Ang Chin Han,

Thank you very much !!

Though I'm not understand you meaning very well, I appreciate your comment !! No one give me such useful information from the English world !!

However, I'm not sure on 2 points:

1. "map HKSCS to UNICODE"
- String big5 = String.getbyte(request.getParameter("hk_field"), "Big5");

2. "duplicate Big5's code in pgsql to support HKSCS natively."
- I don't understand how to do this.

Ang Chin Han <angch@bytecraft.com.my> wrote:
Dennis Gearon wrote:

Isn't HKSC one of the languages supported by UNICODE? I thought they had
every langauge past and present in it.

You'll have to map HKSCS to UNICODE yourself before the data hits
postgresql, and data out of postgresql would be in UNICODE, and up to
you to convert back to HKSCS after retrival. pgsql doesn't have *native*
HKSCS support.

HKSCS is an extension of Big5 right? From the info we have:

http://www.unicode.org/faq/unicode_iso.html
http://www.info.gov.hk/digital21/eng/hkscs/download/big5-iso.txt

We might be able to duplicate Big5's code in pgsql to support HKSCS
natively.

I don't have experience with HKSCS nor test materials to attempt it though.

--
Linux homer 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
4:00pm up 287 days, 7:33, 8 users, load average: 6.32, 6.34, 6.18

ATTACHMENT part 2 application/pgp-signature

嚙踝蕭茪H嚙踝蕭嚙踝蕭嚙畿嚙畿嚙衛世嚙諄人嚙畿嚙皚嚙踝蕭...
嚙踝蕭嚙踝蕭嚙窮嚙緯 嚙踝蕭嚙賠連繫
http://ringtone.yahoo.com.hk/

Hi Ang Chin Han,

Yes, HKSCS just an extension of Big5, if pgsql could support natively,
that is lovely. :-{}

Gordon

Ang Chin Han wrote:

Gordon Luk <gordon@gforce.ods.org> writes:

Yes, HKSCS just an extension of Big5, if pgsql could support natively,
that is lovely. :-{}

Presumably you could extend the existing big5 support, then. See
src/backend/utils/mb/conversion_procs/utf8_and_big5/

regards, tom lane