Link to home
Start Free TrialLog in
Avatar of kcchow
kcchow

asked on

How to insert simplified chinese character in oracle through JSP

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();
%>
      

Avatar of krispols
krispols

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
Avatar of kcchow

ASKER

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
Hello kcchow,

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

regards
Avatar of kcchow

ASKER

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....
ASKER CERTIFIED SOLUTION
Avatar of CetusMOD
CetusMOD
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial