Help!! Chinese(Big 5) Display Problem

Greenhorn

Posts: 18

posted 22 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I created a database to store articles. The content contains Chinese Big5 code. I can stored it in MySQL, but I have problem displaying the content. The Chinese coding become something like "???Ld". I am not sure this is the Chinese handling problem of MySQL, Linux server or programming. How can I solve it???
This is the page to insert data: http://www.webappcabaret.com/pkin/WEB-INF/insertform.jsp
This is the page to show data (id=articles number): http://www.webappcabaret.com/pkin/WEB-INF/show.jsp?id=2
show.jsp

<%@page language="java" contentType="text/html; charset=big5" %>
<%@page import="java.sql.*" %>
<%@page session="true" %>
<%
/********* Establish connection *********/
  
  try{
    Class.forName("org.gjt.mm.mysql.Driver");
    
  }catch(java.lang.ClassNotFoundException e){
    System.err.println("Error:" + e.getMessage());
  }
  
  Connection conn = null;
  Statement stmt = null;
  ResultSet rs = null;
  try{
    conn = DriverManager.getConnection("jdbc:mysql://hostinWebAppbaret.com/pkin?user=user;password=");
    stmt = conn.createStatement();
    
  }
  catch(SQLException ex){
      
    System.err.println("aq.executeQuery: " + ex.getMessage());
    
  }
/********* End of connection *********/

int refid = 1;
  try{
    
    int para = Integer.parseInt(request.getParameter("id"));
    if(para!=0){
      refid = para;
    }
    
  }
  catch(NumberFormatException e){
    System.err.println("No. Format" + e.getMessage());
  }
  
  
  String sql = "SELECT * FROM articles WHERE refid=" + refid;
  try{
    rs = stmt.executeQuery(sql);
  }
  catch(SQLException ex){
    System.err.println("aq.executeQuery: " + ex.getMessage());
  }  
  
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=big5">
<title>HK hoof</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">

<table width="640" border="1" cellspacing="0" cellpadding="0">

<tr>
<td valign="top" bgcolor="#00CC99">
<%
  if(rs.next()){
    out.print(rs.getString("title"));
%>
</td>
</tr>

<tr>
<td valign="top">
<%
  
  out.print(rs.getString("content"));
%>
</td>
</tr>

</table>
<%
  };
  rs.close();
  stmt.close();
%>

</body>
</html>

--------------------<BR>Java will never die.<P>Kenneth

Don't get me started about those stupid light bulbs.