thanks for the anaylysis of my problem...
will try these and see what happens.

regards
*******************************************************
Haresh Gujarathi,

Director,
eMantra Technologies Pvt. Ltd.

http://www.emantratech.com <http://www.emantratech.com/>

Uddhav Sadan, Madiwale Colony,
1992 Sadashiv Peth, Pune 411030, INDIA

Phone: +91 - 20 - 446 1177
*******************************************************





-----Original Message-----
From: Masaki Ikeda [mailto:masaki@xxxxxxxxxx]
Sent: Monday, May 12, 2003 3:58 PM
To: ml@xxxxxxxxxx
Subject: [mysql 07686] Re: why certain Japanese characters are getting
displayed as wrong characters?



Hi

On Mon, 12 May 2003 14:06:21 +0530
In why certain Japanese characters are getting displayed as wrong
characters?
"eMantra Information" <info@xxxxxxxxxx> Wrote

> The data is entered in Japanese (Shift_JIS) in the html form and
> JSP stores the data in the MySQL database.

A special character as 2nd byte may come by ShiftJIS encoding.
for example, -- They are ', \ , etc.
Therefore, it will become inaccurate as SQL syntax, or some characters
will be corrupted.

There are two methods of solution.

1:Escape of the special character.
A character with a meaning special as SQL syntax will be escaped.
Which needs escape are '(0x27), "(0x22), \(0x5C) , and maybe %(0x25).

2: Use another encoding.
You may use UTF-8 or EUC-JP encoding instead of Shift_JIS encoding.
Probably this method is more easier.
However, this method may be unable to be taken if already have many data
by Shift_JIS, or have to use JIS X 0201 characters.

Since you are using Tomcat, I will think that JIS X 0201 characters is
throwing away from the beginning :-)

A special character is not used in UTF-8 or EUC-JP. Therefore, a problem
will not happen even if you do not do special processing.

best regards

# "Jap" is not shortening expression of "Japanese" but insult word.
# There may be some offended persons :-<
# Probably, it will be better not to use at a public place, although I
# have not made it mind so much.

--

Masaki Ikeda <masaki@xxxxxxxxxx>
    Orange System Co.