hi, your config supports european charcters : mysql> select * from tst; +------+---------------------------------------------------+ | a | txt | +------+---------------------------------------------------+ | 1 | Ceci est un test en Français | | 1 | se facilitará el conocimiento de la evolución del | +------+---------------------------------------------------+ 2 rows in set (0.00 sec)
mysql> show variables like '%coll%'; +----------------------+-------------------+ | Variable_name | Value | +----------------------+-------------------+ | collation_connection | latin1_swedish_ci | | collation_database | latin1_swedish_ci | | collation_server | latin1_swedish_ci | +----------------------+-------------------+ 3 rows in set (0.00 sec) have you tried some inserts to see if it is an import problem, or just the client display ? Mathias Selon "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>: > Hi, > > I recently upgraded from 4.0 to 4.1 because of the multilingual support. > > But importing the DB dump into the new 4.1 version all foreign characters > (french, spanish, portoguese) have been replaced by ? character... > > I've been trying to understand the new "collation" feature but i seems quite > difficult to setup. > > Anybody has already faced this problem ? > > Here's my current configuration: > > 1) my.cnf (only the mysqld section) > > [mysqld] > user = mysql > pid-file = /var/run/mysqld/mysqld.pid > socket = /var/run/mysqld/mysqld.sock > port = 3306 > # Both location gets rotated by the cronjob. > #log = /var/log/mysql.log > log = /var/log/mysql/mysql.log > basedir = /usr > datadir = /db > tmpdir = /tmp > language = /usr/share/mysql/english > > 2) Output show variables like '%char%'; > > character_set_client utf8 > character_set_connection utf8 > character_set_database latin1 > character_set_results utf8 > character_set_server latin1 > character_set_system utf8 > character_sets_dir /usr/share/mysql/charsets/ > > 3) Out put show variables like '%coll%'; > > collation_connection utf8_general_ci > collation_database latin1_swedish_ci > collation_server latin1_swedish_ci > > Thanks for any help > > Regards > > Roberto Jobet > > > > ____________________________________________________________ > 6X velocizzare la tua navigazione a 56k? 6X Web Accelerator di Libero! > Scaricalo su INTERNET GRATIS 6X http://www.libero.it > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]