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. :) > > Regards > > Lenin > > www.twitter.com/nine_L <http://www.twitter.com/nine_L> I just converted all, or thought I did. phpMyAdmin: in the structure view of the db show Collation as latin_swedish_ci ??? in the individual table structure views the fields show utf-8 general ??? I don't see any difference on Firefox running on FreeBSD but it show correctly on Wimpy XP ??. In the web page the accent for French shows as a ? within a white diamond on FBSD. In the database the entry is the French chatacter with the accent. I'm now trying to figure out how to enter the accents on FBSD in Firefox. Nuts! This is torcher. How does one become truly international? -- Hervé Kempf: "Pour sauver la planète, sortez du capitalisme." ------------------------------------------------------------- Phil Jourdan --- pj@xxxxxxxxxxxxx http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
