Thank you for your reply, but I'm afraid it doesn't help :( The new setup we are moving to is utf-8 only (Apache, mysql). Making some of the data latin1 and some of it utf-8 will complicate things, we want to move away from different character encodings, which is why we are using unicode in the new setup.
> -----Original Message----- > From: [EMAIL PROTECTED] > Sent: Mon, 20 Feb 2006 13:01:20 -0500 > To: [EMAIL PROTECTED] > Subject: Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8 > > 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
