Salut, je vois que tu es français, j'aimerai bien continuer en français mais il vaut mieux en anglais si jamais il y avait quelqu'un avec le même problème ;-)
So what I'm trying to achieve is to have UTF-8 databases in order to support multilingual content. But first I have to understand how to recover foreign characters in my DB. What do you mean by: "try some inserts to see if it is an import problem " or "just the client display" ? Merci d'avance Roberto Jobet > hi, > your config supports european characters : > > 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]
