Thread: Does postgresql support HKSCS ?

Does postgresql support HKSCS ?

From
Eric Tan
Date:
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

Re: Does postgresql support HKSCS ?

From
Dennis Gearon
Date:
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.



Re: Does postgresql support HKSCS ?

From
Ang Chin Han
Date:
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

Re: Does postgresql support HKSCS ?

From
Gordon Luk
Date:
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.
>



Re: Does postgresql support HKSCS ?

From
Tom Lane
Date:
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

Re: Does postgresql support HKSCS ?

From
Eric Tan
Date:
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/