File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes Inserting Japanese text into Oracle database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "Inserting Japanese text into Oracle database" Watch "Inserting Japanese text into Oracle database" New topic

Inserting Japanese text into Oracle database

Kirtikumar Puthran
Ranch Hand

Joined: Mar 04, 2003
Posts: 37
I apologise if this is not the right forum to ask this question.
I am using Struts framework for my application. I am trying to insert Japanese data retrieved from a JSP page having
"shift-jis" charset into an UTF-8 oracle database.
I am using the following code to get the user input from the Form text box
field as follows:
String textboxString = request.getParameter("japaneseText");
String original = new
byte[] JISBytes = original.getBytes("Shift_JIS");
String insertToDB = new String(JISBytes, "UTF8");
The string is then inserted in a UTF-8 database
But when the string is retrieved from the database using Java or Perl code,
the result is seen as junk "Mojibake" characters.
Note : When the data is inserted using a Perl script, the data is inserted
properly and the results are also retrieved properly in Japanese characters.
I would appreciate if someone could throw some pointers on this issue.

Regards,<br />Kirti
Xavier-Philippe Tulenew

Joined: Jan 28, 2004
Posts: 2
The problem come from Oracle database, the base must be encoding with japanese encoding before the creation of the database. Elsewhere all your characters will be converting in default encoding....
I agree. Here's the link:
subject: Inserting Japanese text into Oracle database
jQuery in Action, 3rd edition