Hi, Thanks for your help.
Usually to export and import dump files I use phpmyadmin, so I'm not very much familiar with the mysqldump command-line utility :-)) In the command line that you specify below, do I have to indicate the db name ? Thanks in advance Regards Roberto Jobet > Hello. > > If you're sure that data in your dump file is in latin1 character > set, you could perform something like: > > mysql --default-character-set=latin1 < dump_file > > > > > "Roberto Jobet" <[EMAIL PROTECTED]> wrote: > > Hi, > > > > > >> Hello. > >> > >> > >> Check the character sets with the following = > > statement: > >> show variables like '%char%'; > > > > Here's the output: > > > > ch= > > aracter_set_client utf8 > > character_set_connection utf8 > > character_set_d= > > atabase latin1 > > character_set_results utf8 > > character_set_server latin1= > > > > character_set_system utf8 > > character_sets_dir /usr/share/mysql/charse= > > ts/ > > > > > >> What version of mysqldump did you use to perform a dump? Ver= > > sions from > >> 4.1.x distributions usually put SET NAMES=3D'utf8' in the b= > > eginning 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 ad= > > vance > > > > Regards > > > > Roberto Jobet > > > >> "[EMAIL PROTECTED]" <roberto= > > [EMAIL PROTECTED]> wrote: > >> > Hi, > >> > > >> > Thanks for your reply. > >> > = > > > >> > What do you mean by "right character set=3D > >> > " ? > >> > The defau= > > lt character set for ver. 4.1 is latin1, right ? This set s=3D > >> > hould= > > > >> > support all western european languages ! > >> > > >> > Regarding --def= > > ault-ch=3D > >> > aracter-set command in chapter 10 is written that a way t= > > o > >> > change settin=3D > >> > gs is to recompile... > >> > Is there another = > > less painful way to do this ? > >> > =3D0D > >> > =3D > >> > Thanks in advance=0D > > = > >> > > >> > Roberto Jobet > >> > > >> > > >> >> Hello. > >> >> > >> >> Specify the= > > right=3D > >> > character set with --default-character-set command > >> >> l= > > ine option for my=3D > >> > sql (if you're using it for reading dump). Chap= > > ter 10 > >> >> of the manual co=3D > >> > uld be helpful. See: > >> >> http:/= > > /dev.mysql.com/doc/mysql/en/charset.html=3D0D > >> > =3D > >> >> > >> >> > >> >= > >> > >> >> > >> >> "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wro=3D= > > > >> > te: > >> >> > Hi, > >> >> > > >> >> > I'm trying to import a db dump mad= > > e on ver. 4.0, =3D > >> > on a new 4.1 vers=3D3D > >> >> > ion. > >> >> > > >> >= > >> > All accented characters (french=3D > >> > , spanish) are replaced by a = > > '?'=3D3D0D > >> >> > =3D3D > >> >> > > >> >> > What it's the r=3D > >> > ight wa= > > y to import it ? > >> >> > > >> >> > > >> >> > Thanks in advance > >> >> > > >> = > >>> > Rob=3D > >> > ert=3D3D > >> >> > o Jobet > >> >> > =3D3D0A=3D3D0A=3D3D0A=3D= > > 3D0A____________________________=3D > >> > ________________________=3D3D=0D > > = > >> >> > ________=3D3D0ANavighi a 4 MEGA e i primi =3D > >> > 3 mesi sono GRA= > > TIS. =3D3D0AScegli Liber=3D3D > >> >> > o Adsl Flat senza limiti su=3D > >> >= > > http://www.libero.it=3D3D0A > >> >> > > >> >> > > >> >> > >> >> > >> >> > >> =0D > > = > >> > > -- > 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 > > > > > -- > 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]
