Huib schrieb: > > Hello, > > I hope that this is the right list. > > I have a database that has been running for years in latin1 but a > software update changed it in to utf8 that would be no big deal if we > know it right away so we could change the database. > > The big problem is that the database has been running for 2 months as > utf8 and it is causing problems now. I have like 500mb latin1 and > 100mb utf in the database. > > How can I convert the database to utf8 without breaking it? >
in short that is bad, i would do a unload/load cycle you can easly use recode/iconv or friends to convert the problem is that you have to check carefully no to convert to much. If you can unload only the Latin1 that would be a great help, also having binary data will make thinks more complicated. re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org