Hi,
> Hello. > > > Check the character sets with the following statement: > show variables like '%char%'; Here's the output: 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/ > What version of mysqldump did you use to perform a dump? Versions from > 4.1.x distributions usually put SET NAMES='utf8' in the beginning of the > dump file. These are the first 2 lines of the dump file: -- phpMyAdmin SQL Dump -- version 2.6.1-rc1 Now what should I do exactly to correctly import all foreign characters ? Thanks in advance Regards Roberto Jobet > "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > > Hi, > > > > Thanks for your reply. > > > > What do you mean by "right character set= > > " ? > > The default character set for ver. 4.1 is latin1, right ? This set s= > > hould > > support all western european languages ! > > > > Regarding --default-ch= > > aracter-set command in chapter 10 is written that a way to > > change settin= > > gs is to recompile... > > Is there another less painful way to do this ? > > =0D > > = > > Thanks in advance > > > > Roberto Jobet > > > > > >> Hello. > >> > >> Specify the right= > > character set with --default-character-set command > >> line option for my= > > sql (if you're using it for reading dump). Chapter 10 > >> of the manual co= > > uld be helpful. See: > >> http://dev.mysql.com/doc/mysql/en/charset.html=0D > > = > >> > >> > >> > >> > >> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wro= > > te: > >> > Hi, > >> > > >> > I'm trying to import a db dump made on ver. 4.0, = > > on a new 4.1 vers=3D > >> > ion. > >> > > >> > All accented characters (french= > > , spanish) are replaced by a '?'=3D0D > >> > =3D > >> > > >> > What it's the r= > > ight way to import it ? > >> > > >> > > >> > Thanks in advance > >> > > >> > Rob= > > ert=3D > >> > o Jobet > >> > =3D0A=3D0A=3D0A=3D0A____________________________= > > ________________________=3D > >> > ________=3D0ANavighi a 4 MEGA e i primi = > > 3 mesi sono GRATIS. =3D0AScegli Liber=3D > >> > o Adsl Flat senza limiti su= > > http://www.libero.it=3D0A > >> > > >> > > >> > >> > >> > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com ____________________________________________________________ 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]