File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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....
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Inserting Japanese text into Oracle database
 
Similar Threads
Internationalisation - Japanese Characters
Inserting Japanese text into Oracle database
Display problem with Japanese characters
Inserting Japanese text into Oracle database
Regarding insertion of Japanese charachters in UTF-8 database