michael_wu[吳宏達] wrote: > Many thanks! I had downloaded V4.1.1 and created a database in utf8 > character set. > I successfully created a table and inserted rows of data with VARCHAR > columns into the table through the SQL pad. > With the Control Center GUI, I can see the result. It seems the data in the > table are right. I can see the multiple byte > characters in the varchar columns. However, when my application selected > data through JDBC, the returned strings are wrong. > Looks the returned strings are not in the right character set.
How are you displaying the data returned via JDBC? As a JSP page or in a Java GUI (Swing/AWT) app? If the former, servlet containers default to ISO-8859-1 encoding... What version of Connector/J are you using, and are you specifying Unicode and charset in your connection URL, e.g. jdbc:mysql://localhost/test?useUnicode=true&characterEncoding=UTF-8 -- Hassan Schroeder ----------------------------- [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
