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.