aspose file tools*
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
Author

Inserting Japanese text into Oracle database

Kirtikumar Puthran
Ranch Hand

Joined: Mar 04, 2003
Posts: 37
Hi,
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
String(textboxString.getBytes("8859_1"));
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
Greenhorn

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: http://aspose.com/file-tools
 
subject: Inserting Japanese text into Oracle database