Thread: Does postgresql support HKSCS ?
Hi all,
I would like to setup a database which can accept HKSCS - "Hong Kong Supplementary Character Set". Here is the reference:
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
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/> > 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
Attachment
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/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.
>
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
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
兩個人的幸運、亂世佳人、遇見...
浪漫鈴聲 情心連繫
http://ringtone.yahoo.com.hk/