Re: utf-8 ?
| From: | 9el | Date: | Mon, 27 Apr 2009 14:56:23 +0000 |
| Subject: | Re: utf-8 ? | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-292025@lists.php.net to get a copy of this message | ||
> 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. :)
Regards
Lenin
www.twitter.com/nine_L