Mark Dacasco wrote: > SHOW VARIABLES LIKE ''%char%; > character_set_client utf8 > character_set_connection utf8 > character_set_database utf8 > character_set_results utf8 > character_set_server latin1 > character_set_system utf8 > > SHOW CREATE TABLE `table1`; > CREATE TABLE `main_peeps` ( > `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Primary Key', > `test` varchar(255) NOT NULL default '' COMMENT 'Test', > PRIMARY KEY (`id`), > ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='COMMENT HERE' > >> Please, send the output of the following statements: >> >> show variables like '%char%'; >> >> show create table table1; > > >
adding to the section "[mysqld]" of the file my.cnf "character-set-server = utf8" solves the problem ? -- .................................................................... . These pages are best viewed by coming to my house and looking at . . my monitor. [S. Lucas Bergman (on his website)] . .................................................................... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]