By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,661 Members | 1,330 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,661 IT Pros & Developers. It's quick & easy.

Does postgresql support HKSCS ?

P: n/a
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

「向左走 向右走」趣怪 VoiceMail 歡迎詞....
http://voicemail.yahoo.com.hk

Nov 12 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.yahoo.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*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 12 '05 #2

P: n/a
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+uAJwKr3TloIr309ls/qaz0WA6tPUG4gCgwEOF
1xVfg6hYwd7657XLS9FL2g0=
=gKus
-----END PGP SIGNATURE-----

Nov 12 '05 #3

P: n/a
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 YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #4

P: n/a
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_procs/utf8_and_big5/

regards, tom lane

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

Nov 12 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.