Hello.
> Regarding --default-ch aracter-set command in chapter 10 is written that a >way to change settings is to recompile... > Is there another less painful way to do this ? You may specify default character sets using options when you start mysqld. See: http://dev.mysql.com/doc/mysql/en/charset-server.html Check the character sets with the following statement: show variables like '%char%'; 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. "[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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
