Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

How to insert simplified chinese character in oracle through JSP

Posted on 2003-10-26
6
2,535 Views
Last Modified: 2008-02-07
Oracle 8i 8.1.7
IBM RS6000 AIX5L
NLS_LANGUAGE=SIMPLIFIED CHINESE
NLS_TERRITORY=CHINA
NLS_CHARACTERSET=ZHS16GBK
NLS_NCHAR_CHARACTERSET=USASCII7

I have tried to update a field (varchar(100) or varchar2(100)) with simplified chinese character through JSP but failed ('????' are shown). Please help!

Here is my code:

<%@ page contentType="text/html; charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.net.*" %>
<%@ page import="beans.*" %>
<jsp:useBean id="SQL" scope="request" class="beans.SQLConnection">
<jsp:setProperty name="SQL" property="driverName" value="oracle.jdbc.driver.OracleDriver"/>
<jsp:setProperty name="SQL" property="jdbcURL" value="jdbc:oracle:oci8:@ora8"/>
<jsp:setProperty name="SQL" property="username" value="aaaa"/>
<jsp:setProperty name="SQL" property="password" value="bbbb"/>
</jsp:useBean>
<%
      String strA = "&#20630;&#39649;&#36617;&#38484;&#35473;&#38596;&#34656;&#30498;&#26740;";
      String strA1 = new String(strA.getBytes("ISO-8859-1"), response.getCharacterEncoding());
      
%>      
Character Encode - <%=response.getCharacterEncoding()%><br>
Original - <%=strA %><br>
ISO to gb2312 - <%=strA1 %><br>
<p>
<%      

            SQL.openDB();
            
            String strsql = "UPDATE testtable SET f1 = '" + strA1 +"'";
            String[] SQLstmts = new String[1];
            SQLstmts[0] = strsql;
            SQL.execUpdate(SQLstmts);
      %>
0 - <%=strsql %><p>
<h1>RESULT</h1>
<%
            strsql = "SELECT f1 FROM testtable";
            SQL.execSQL(strsql);


            while(SQL.nextRow())
            {

                  strA = SQL.getField("f1");
                  strA1 = new String(strA.getBytes(response.getCharacterEncoding()), "ISO-8859-1");


%>
Original - <%=strA %><br>
gb2312 to ISO - <%=strA1 %><br>
<p>
<%
            }

            SQL.closeDB();
%>
      

0
Comment
Question by:kcchow
  • 2
  • 2
6 Comments
 
LVL 3

Expert Comment

by:krispols
ID: 9631887
hello kcchow,

With Oracle to support unicode, you must use UTF-8 charset.
Go and see this link http://otn.oracle.com/products/oracle8i/pdf/ecomwp.pdf

regards
0
 

Author Comment

by:kcchow
ID: 9633404
Thank you krispols. But I need to use ZHS16GBK for the database.
 By the way, is there any effect if I have using JDK version 1.1.8
0
 
LVL 3

Expert Comment

by:krispols
ID: 9639886
Hello kcchow,

Is not possible to use JSP and servlet with JDK 1.1.8. Which is your web container?

regards
0
 

Author Comment

by:kcchow
ID: 9672643
Problem solved. I have added the NLS_LANG=AMERICAN_AMERICA.ZHS16GBK in jserv.properties.

By the way, I have tried to add NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK" but error "Invalid NLS parameter values" shown. I seems that NLS_LANGUAGE and NLS_TERRITORY must be in default value in jserv.properties....
0
 

Accepted Solution

by:
CetusMOD earned 0 total points
ID: 10784959
PAQed, with points refunded (500)

CetusMOD
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
constructor overloading 2 86
JSONSerializer.toJSON in JSP generating error 8 80
spring example errors 33 397
web application structure 18 95
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Most MSPs worth their salt are already offering cybersecurity to their customers. But cybersecurity as a service is wide encompassing and can mean many things.  So where are MSPs falling in this spectrum?
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question