characterEncoding has no effect in connection url

Under Redhat as4 x86_64  

This is my java program:  

import java.sql.*;  

public class JdbcExample3 {  

  public static void main(String args[]) {     Connection conn = null;  

    try {

      Class.forName("com.mysql.jdbc.Driver").newInstance();
      conn = DriverManager.getConnection("jdbc:mysql://10.11.17.85/test?useUnicode=false&characterEncoding=utf8",
        "test", "");
 
      if(!conn.isClosed())
        System.out.println("Successfully connected to " +
          "MySQL server using TCP/IP...");
 
      Statement s = conn.createStatement ();
      s.executeQuery ("SELECT t FROM test");
      ResultSet rs = s.getResultSet ();
      int count = 0;
      while (rs.next ())
      {
          String tVal = rs.getString ("t");
          System.out.println (
                  " t = " + tVal
                  );
          ++count;
      }
      rs.close ();
      s.close ();
      System.out.println (count + " rows were retrieved");
 

    } catch(Exception e) {

      System.err.println("Exception: " + e.getMessage());

    } finally {

      try {
        if(conn != null)
          conn.close();
      } catch(SQLException e) {}

That program fetches some Chinese words from MySQL.  

When I changed characterEncoding=utf8 to characterEncoding=latin1 or any existed character set, the output won't change.  

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

It seems that characterEncoding= is no use in jdbc url.  

The output is dependent on environment variable LANG. When I change LANG, the output will also change.  

Driver is mysql-connector-java-5.0.7.  

MySQL Server's version is 5.0 and 5.1.  

Why characterEncoding in url has no effect?

·Ç³£¸Ðл£¬×£ÄúÒ»ÇÐ˳Àû

¹ÅÀ×
Network Operation Dept
Tel:62728824
Mobile: 13501384181
Email: leigu@sohu-inc.com
msn: gl_yuanjue@hotmail.com
gtalk:gulei.om@gmail.com   Received on Fri Aug 10 05:10:51 2007