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'
Try it again when 4.1.1 comes out. There is a bunch of character set renaming that went on between 4.1.0 and 4.1.1.
Also, COLLATE need be specified only once. :-) I assume the double COLLATE above is just a typo?
What you're seeing is one of the things referred to by:
http://www.mysql.com/doc/en/Charset.html
which says:
The features described here are as implemented in MySQL 4.1.1. (MySQL 4.1.0 has some but not all of these features, and some of them are implemented differently.)
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]
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]