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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
