Re: characterEncoding has no effect in connection url

Gu Lei(Tech) wrote:
> I also tried useUnicode=true. It's the same.
>
>

I would try to write to a File instead of System.out. And then look in the file with an UTF8 capable editor. When it is okay, then the System.out implictly converts your utf8 to another code.

For instance:
FileOutputStream fos = new FileOutputStream(args[0]); OutputStreamWriter osw = new OutputStreamWriter(fos, "UTF-8");

When the content of the file is not okay, try to write a UTF8 string into the database before you process a SELECT on the same data and write it to file (or even System.out).
If this method results in correct data, then your data in the MySQL DB is not correct UTF-8. And you have to adjust the database engine or the (other?) program which you used to import the data into the DB.

Ronald

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