I'm trying to create a table in my database with
CHARACTER SET utf8 COLLATE COLLATE utf8_general_ci
Answer is
ERROR 1115: Unknown character set: 'utf8_general_ci'
What am I doing wrong, if anything? Please find details on my server and
the table I'm trying to create below:
mysql> select version();
+---------------------+
| version() |
+---------------------+
| 4.1.0-alpha-Max-log |
+---------------------+
The SQL statement I'm trying to execute is:
CREATE TABLE blahagent (
id VARCHAR(100) CHARACTER SET latin1 DEFAULT '' NOT NULL,
last_name VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT
NULL,
first_name VARCHAR(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '' NOT NULL,
PRIMARY KEY(id)
);
Yours
Sigfrid
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
