As some of you might have noticed, I committed a revised update script the other day. The big change this time is that the update script contains code that runs through all the text in your database and encodes it into UTF-8.
I talked about this in my previous post about the UTF-8 migration. However, in that post I discussed taking a database dump, running iconv on it and then re-importing it. With the new update script, that won’t be necessary unless the current encoding is non-ISO-8859-1 and the PHP environment lacks iconv and mbstring support. I believe this scenario will be relatively uncommon, particularly since any PHP5 environment should have iconv right out of the box. For ISO-8859-1, there’s no need for iconv or mbstring since we can use PHP’s built-in utf8_encode() function.
It would be great if you guys could test the new script. I’ve run it on a couple of semi-large database dumps and it appears to work just fine, but there’s only so many test cases I can come up with on my own. Do remember to make a backup of anything you attempt to convert.
Nice, this should ease the process of upgrading by quite a bit.
March 14th, 2007, at 12:32 am #If I use this script on my 1.2 install and not upgrade straight away to 1.3 beta, will new text added be non-UTF-8?
March 14th, 2007, at 4:00 am #Can’t quite test on large dump, I already have everything in utf8. But don’t forget that case in the converter 1.2->1.3, some people were already in utf-8, even if it wasn’t officially supported :)
March 14th, 2007, at 4:01 am #Trakman: Don’t run it on your 1.2 database if you don’t intend to update to 1.3.
Jérémie: It’s not a problem. The conversion procedure is safe in the sense that it can be run any number of times without causing any problems.
March 14th, 2007, at 8:08 am #hehe i hope 1.3 will be released soon. I wanna have all my “mods” as extensions XD
March 15th, 2007, at 11:47 am #and please let us have mutiple group per user (whichever the user is)
I added it to my 1.2 install but this starts to make so much modifications to the db >.
I’m curious. Has anyone tested the new update script on a non-English database?
April 17th, 2007, at 1:05 pm #I’m still curious if anyone has tested the update script on a non-English database.
September 18th, 2007, at 12:45 pm #