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]
