I also had problems converting latin1 to utf-8. For whatever reason, accents and stuff did not convert.
The solution was not to convert to utf-8. If you create your tables with the character set of latin1, you should be fine (that's what we did). After all, you are already upgrading -- why change the table type while you're at it? You want to make sure any problems you encounter are upgrade-related, not related to the changing of the table type. if you're not getting that in your mysqldump, use the --create-options flag to mysqldump to get it. (make sure you're not running --compatible=[something not mysql]). Hope this helps! -Sheeri On 2/18/06, David Spidley <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > > From: [EMAIL PROTECTED] > > Sent: Sat, 18 Feb 2006 00:12:19 +0100 > > To: [EMAIL PROTECTED] > > Subject: Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8 > > > > On 17.02.2006 15:34 (+0100), David Spidley wrote: > >> What is the official way to take this latin1 3.23 dump and load it > >> into the brand new 4.1 utf-8 database, with the characters being > >> converted during the load? > > > > I'm not sure if the official way will help you. I've tried to copy a 4.0 > > database (latin1) to 5.0 (utf-8) and couldn't make it work with MySQL > > Administrator's tools. phpMyAdmin made a good impression though, and it > > got a lot faster since couple of years ago! You could export the > > database as latin1 and re-import it as utf-8 or so. Just give it a try... > > Great! How can I do this so that it works? > Everything I have tried has failed. > > (I would like to stick to command line stuff if possible.) > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
