On Mon, 2009-04-27 at 20:56 +0600, 9el wrote: > > I looked at http://developer.loftdigital.com/blog/php-utf-8-cheatsheet > > which suggests this: > > ALTER DATABASE db_name > > CHARACTER SET utf8 > > DEFAULT CHARACTER SET utf8 > > COLLATE utf8_general_ci > > DEFAULT COLLATE utf8_general_ci > > ; > > > > ALTER TABLE tbl_name > > DEFAULT CHARACTER SET utf8 > > COLLATE utf8_general_ci > > ; > > > > or I could do it with phpMyAdmin, right? > > > > and the only difficulties would appear to be fixing any accent stuff > > (don't know yet just what) and that would only be time consuming. > > > > I guess I'm just looking for reassurance that I don't muck up anything > > and then have to do tortured acrobatics to redress things again. :-) > > > > Changing to UTF8 is time consuming but if programming can be used it would > ease the effort. I have seen a WP plugin for that as well. And in phpmyAdmin > you'll have to set the collation for all fields and tables one by one. :)
I think some time ago I used combination of mysqldump and iconv, some minor editing, and then pumped it back into the database. Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
