At 5:23 PM +0200 9/15/03, Sigfrid Lundberg - LUB NetLab wrote:
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]



Reply via email to