look at automatic character set conversion http://dev.mysql.com/doc/mysql/en/charset-collation-charset.html
mathias Selon [EMAIL PROTECTED]: > Salut, > i don't see what doesn't work ! Where characters are replaced by ?, since you > say that insert,select and import work fine ? is it in the export ? > > see http://dev.mysql.com/doc/mysql/en/upgrading-from-4-0.html for migration. > > > Mathias > > Selon "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>: > > > Voilà, > > > > Everything works fine: insert, select and importing. I have always the same > > text: > > > > 'Ceci est un test en Français' > > > > So what could be the problem ? and how to recover foreign characters ? > > > > Thanks > > > > Roberto Jobet > > > > > > > i mean : > > > if you launch : > > > into into table (toto) values ('Ceci est un test en Français'); > > > then : > > > select toto from table; > > > > > > can you read it correctly ? And if the same row is imported, is there any > > > difference ? > > > > > > A bientôt > > > Mathias > > > > > > > > > Selon "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>: > > > > > > > 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] > > > > > > > > > > > > > > > > > > > > > > > > > ____________________________________________________________ > > 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]