Hello,

We have developed a HTML-JSP-JavaBean-MySQL web application supporting
Japanese data entry and Japanese language data display.

We have a HTML FORM, JSP, Tomcat4.0, MySQL 3.23.41.

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

For every request coming on server we are doing
request.setCharacterEncoding ("Shift_JIS");

We store the Jap text in MySQL and then then retrieve and display on html
page.
I can retrieve this Japanese data from db and display on screen in Japanese.

So when I enter the text ??  it gets into the db and then if I query and
display back in html it gets displayed as ??. Many other characters are
getting saved in Database and retrieved back properly.


Can somebody throw light on this?

Since the Jap characters may not come up in this forum html pages...
I have put GIF and txt files on following link. These pages will show u the
intended Jap characters and the actual characters coming up on html page
Please visit following links to view the pages, and do provide some
information regarding this behavior
http://www.emantratech.com/jap_text/japanese-text-problem.htm
http://www.emantratech.com/jap_text/event3731.gif


I have some more data regarding this problem

1. when the user enter the correct words in the form and send to server, I
again display that data for confirmation to the user. This time it displays
fine.

but when I think it goes to the database and then comes back on the html
page, that time it gets corrupted?

2. this problem occurs if I save the jap text in MySQL and and then query it
for display purpose. Rest of the data seems to be fine

3. the two characters which get corrupted are following
U34920 (x8868), U29694(x73FE)

4. I try to save U34920,U29694 in the database. What I get back from the
database is
U65403(xFF7B),U38428(x961C)

5. if I try to save just one character U29694 it works fine. What I get back
from DB is original character.
BUT if I try to save the other character U34920
I get SQL Syntax error...

"Syntax error or access violation: You have an error in your SQL syntax near
''?\')' at line 1 "


PLEASE RESPOND IN ENGLISH AS I AM FROM INDIA AND HAVE NO UNDERSTANDING OF
JAPANESE LANGUAGE.

regards

Haresh Gujarathi