At 13:56 +0200 7/5/04, Pascal Francq wrote:
Hi,
I try to create with MySQL 4.0.18 a database with unicode as default character
set. So I use the command:
CREATE DATABASE db_name DEFAULT CHARACTER SET utf8;
I receive the message when i try this command:
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'DEFAULT CHARACTER SET utf8' at line 1.
It's a version issue. You must have at least 4.1.1 to use that clause:
http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html
http://dev.mysql.com/doc/mysql/en/Charset.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
