Does postgresql support HKSCS ?

[Eric Tan]

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...roduction.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

[Dennis Gearon]

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...roduction.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.ya hoo.com/>

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.

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Ang Chin Han]

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...d/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

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE/hR/WNYbTUIgzwfARAh +uAJwKr3TloIr30 9ls/qaz0WA6tPUG4gCg wEOF
1xVfg6hYwd7657X LS9FL2g0=
=gKus
-----END PGP SIGNATURE-----

[Gordon Luk]

Hi Ang Chin Han,

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

Gordon

Ang Chin Han 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...d/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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to ma*******@postg resql.org)

[Tom Lane]

Gordon Luk <go****@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_proc s/utf8_and_big5/

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org