-----Original Message----- From: michael_wu[吳宏達] Sent: Tuesday, May 25, 2004 3:08 PM To: '[EMAIL PROTECTED]' Subject: RE: create database in specified character set
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. Could some one tell me what mistakes I had made? Regards, -----Original Message----- From: Hassan Schroeder [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 12:19 PM To: [EMAIL PROTECTED] Subject: Re: create database in specified character set michael_wu[吳宏達] wrote: > I am evaluating the utf8 support of MySQL V4.0.18. I followed the > documentation to create a database as the following: > > CREATE DATABASE trdb CHARACTER SET utf8; > > Strangely, I got syntax error(s). It seems that the reserved words > CHARACTER SET are not recognized. <http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html> "As of MySQL 4.1.1, create_specification options can be given to specify database characteristics. Database characteristics are stored in the `db.opt' file in the database directory. The CHARACTER SET clause specifies ..." That's "4.1.1" -- time to upgrade. :-) HTH! -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]