RE: characterEncoding has no effect in connection url

I also tried useUnicode=true. It's the same.

-----ԭʼÓʼþ-----
·¢¼þÈË: Gu Lei(Tech) [mailto:leigu@sohu-inc.com]
·¢ËÍʱ¼ä: 2007Äê8ÔÂ10ÈÕ 17:10

ÊÕ¼þÈË: java@lists.mysql.com
Ö÷Ìâ: 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) {}

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

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.  

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?

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

Do you need more 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

¹ÅÀ×
Network Operation Dept
Tel:62728824
Mobile: 13501384181
Email: leigu@sohu-inc.com
msn: gl_yuanjue@hotmail.com
gtalk:gulei.om@gmail.com  

-- 
MySQL Java Mailing List
For list archives: 
http://lists.mysql.com/java
To unsubscribe:    
http://lists.mysql.com/java?unsub=lists@pantek.com