Re: Questions about unicode.

From: "Karen Ellrick" <k-ellrick(at)sctech(dot)co(dot)jp>
To: "Corn" <corn(at)tryit(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Questions about unicode.
Date: 2001-09-04 00:31:10
Message-ID: GAELLCMOCEGMDMHDMIILEEJPCMAA.k-ellrick@sctech.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Corn,

I don't have any experience with Chinese, but I'm writing an application for
Japanese, which has three common encoding formats, or character sets (JIS,
Shift-JIS, EUC), even though they all represent the same actual characters
(unlike Chinese). From what I can tell, the character sets you deal with
are "Big5" (traditional) and "GB2312" (simplified). For Japanese, most
software has a choice of "Japanese - Auto-select", which seems to work most
of the time, but perhaps Chinese is more challenging since there are far
more characters commonly used.

I don't know what interface you are using on your PCs to enter and get data,
but if there is a way in that interface (or code you are writing) to detect
what character set the PC is using, you could add a field in your database
table to indicate what character set was used. Then when the data is
retrieved, the user interface code could get the character set type and tell
the PC to display it using that set. Again, I don't what interface you are
using, but if, for example, you are using a web browser and writing
server-side code (PHP, CGI, etc.) to access the database, you would set the
character set in the header of the HTML, like this:
<meta http-equiv="Content-Type" content="text/html; charset=big5">

You mentioned Unicode in your subject line. I have not been using Unicode
for Japanese, because I have so far had no trouble putting the two-byte
character codes (Shift-JIS, etc.) directly into the database. So if there
are special issues with Unicode, I can't help you with that. If, on the
other hand, you have warnings for me that I should be using Unicode, please
tell me.

I hope this helps.

--------------------------------
Karen Ellrick
S & C Technology, Inc.
1-21-35 Kusatsu-shinmachi
Hiroshima 733-0834 Japan
(from U.S. 011-81, from Japan 0) 82-293-2838
--------------------------------

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Corn
> Sent: Friday, August 31, 2001 11:39 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Questions about unicode.
>
>
> Hi all,
>
> I had create a database that encoded as unicode.
>
> And then, I put some data into the database by two different
> machine(win2000), but using different character set used, Traditional &
> Simplified Chinese.
>
> But I cannot read all chinese in right format. like, on traditional
> windows 2000. I can read traditional chinese only. How can I read both
> traditional & simplified chinese at one pc?
>
> Corn
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-09-04 00:32:40 Re: plpgsql function parameter questions
Previous Message Alex Knight 2001-09-04 00:21:58 Re: [WAY OT] Re: PL/java?