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.
posted 12 years ago
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....