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

kcchowAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

krispolsCommented:
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
kcchowAuthor Commented:
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
krispolsCommented:
Hello kcchow,

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

regards
0
kcchowAuthor Commented:
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
CetusMODCommented:
PAQed, with points refunded (500)

CetusMOD
Community Support Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
JSP

From novice to tech pro — start learning today.