Korean Japenese chars in mysql

[jacques deyrieux]

hi,

on my public server, if i record [ 한국어 ] on my table with phpmyadmin, the chars recorded are [???]
otherwise if i use the module mysql of webmin for record the sames chars, then mysql store [ 한국어 ]

the same database work fine on my own computer with the same apache/mysql/php version.

SHOW VARIABLES LIKE 'character_set%';
character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/
pour faire un peu d'humour, j'en perd mon latin ;)

SHOW CREATE TABLE spip_rubriques;
CREATE TABLE `spip_rubriques` (\n `id_rubrique` bigint(21) NOT NULL auto_increment,\n `id_parent` bigint(21) NOT NULL default '0',\n `titre` text collate latin1_general_ci NOT NULL,\n `descriptif` text collate latin1_general_ci NOT NULL,\n `texte` longblob NOT NULL,\n `id_secteur` bigint(21) NOT NULL default '0',\n `maj` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,\n `export` varchar(10) collate latin1_general_ci default 'oui',\n `id_import` bigint(20) default '0',\n `statut` varchar(10) collate latin1_general_ci NOT NULL,\n `date` datetime NOT NULL default '0000-00-00 00:00:00',\n `lang` varchar(10) collate latin1_general_ci NOT NULL default '',\n `langue_choisie` varchar(3) collate latin1_general_ci default 'non',\n `idx` enum('','1','non','oui','idx') collate latin1_general_ci NOT NULL default '',\n `extra` longblob,\n `url_propre` varchar(255) collate latin1_general_ci NOT NULL,\n `statut_tmp` varchar(10) collate latin1_general_ci NOT NULL,\n `date_tmp` datetime NOT NULL default '0000-00-00 00:00:00',\n PRIMARY KEY (`id_rubrique`),\n KEY `lang` (`lang`),\n KEY `idx` (`idx`),\n KEY `id_parent` (`id_parent`),\n KEY `url_propre` (`url_propre`)\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci


and http encodage = utf-8

thanks for your help

best regards

Jacques