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]