Re: [HACKERS] Re: [PATCHES] Postgres-6.3.2 locale patch (fwd) - Mailing list pgsql-hackers

From t-ishii@sra.co.jp
Subject Re: [HACKERS] Re: [PATCHES] Postgres-6.3.2 locale patch (fwd)
Date
Msg-id 199806040816.RAA13969@srapc451.sra.co.jp
Whole thread Raw
In response to Re: [PATCHES] Postgres-6.3.2 locale patch (fwd)  (Peter Mount <peter@taer.maidstone.gov.uk>)
Responses Re: [HACKERS] Re: [PATCHES] Postgres-6.3.2 locale patch (fwd)  (Peter Mount <peter@taer.maidstone.gov.uk>)
List pgsql-hackers
>In a same vein, for getting JDBC up to speed with this, we may need to
>have a function on the backend that will handle the translation between
>the encoding and Unicode. This would allow the JDBC driver to
>automatically handle a new character set without having to write a class
>for each package.

I already have a patch to handle the translation on the backend
between the encoding and SJIS (yet another encoding for Japanese).
Translation for other encodings such as Big5(Chinese) and Unicode are
in my plan.

The biggest problem for Unicode is that the translation is not
symmetrical. An encoding to Unicode is ok. However, Unicode to an
encoding is like one-to-many. The reason for that is "Unification." A
code point of Unicode might correspond to either Chinese, Japanese or
Korean. To determine that, we need additional infomation what language
we are using. Too bad. Any idea?
---
Tatsuo Ishii
t-ishii@sra.co.jp

pgsql-hackers by date:

Previous
From: Stephane MONEGER
Date:
Subject: Problem with array of char
Next
From: "Jose' Soares Da Silva"
Date:
Subject: TRIGGERS