hello ! I'm using my french host's phpMyAdmin and I'd like to create manually a new table using different character set and collation than default one. This is the code I've used : CREATE TABLE `ru` ( `pkey` INT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY, `titre` TEXT NOT NULL ) CHARACTER SET koi8r COLLATION koi8r_general_ci;
The first part has been generated by phpMyAdmin and I've just added "CHARACTER SET koi8r COLLATION koi8r_general_ci" like it's done in the example from this doc : http://www.mysql.com/documentation/mysql/bychapter/manual_Charset.html#Charset-cyrillic-sets . But I have a syntaxe error in this part of code ! Which is it ? ------------------------------------------ Faites un voeu et puis Voila ! www.voila.fr -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]