Hi,
Have you tried to change your browser's encoding to Big5 in order to view
Chinese characters?
Have you tried to use mysql client to select those multi-byte characters?
Have you seen they are OK?
If you still cannot view strings properly, and you use Java to implement
your system,
try to following code.
==============
ResultSet rset = YOUR_STATEMNT.executeQuery();
while (rset.next())
{
int ch;
StringBuffer answerStrBuf = new StringBuffer();
InputStreamReader isr = new InputStreamReader(rset.getBinaryStream
("MULTI-BYTE-FIELD"), "ISO-8859-1");
Reader in = new BufferedReader (isr);
while ((ch = in.read()) > -1) {
answerStrBuf.append((char) ch);
}
in.close();
out.print(answerStrBuf); // echo your multi byte data.
}
==========
My settings are
Windows 2000 Advanced Server (Traditional Chinese version)
MySQL 3.23.38-max-nt with charset=latin1
multi-byte fields using varchar and varchar binary to store
multi-byted data.
JRun 3.1 Enterprise Server (Developer License).
Hope this help.
----- Original Message -----
From: "FWC Stylist Hong Wong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 8:30 AM
Subject: Chinese PinYin/Traditional Support in mysql?
> Hi
>
> I'd like to be able to input pinyin and Big5 Chinese characters into
> mysql using Jive discussion forum software, e.g. I would input both
> English and Chinese into the same field.
>
> After reading some past postings I understand that I only need to load
> Chinese language support if I want to do sorting/searching, and that
> it's okay to leave mysql using the default Latin language set if I use a
> UI capable of inputting and reading Chinese [running on English Linux
> OS].
>
> I copied and pasted some Chinese text [from a word doc sent by someone
> from China] into my HTML form and posted to the database, the text
> remained as Chinese characters in the text box before posting. On
> pulling the data back from the database it is all garbage???
>
> Would someone be kind enough to offer some advice please on what I'm
> doing wrong and corrective action???
>
> Thanks in advance, Hong.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
