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]
