Hello :)
I've been struggling with a table that has a strange encoding. In phpmyadmin the text displays like this:
ÓíÑÉ ãÎÊÕÑÉ
I call it Martian encoding :P
My site is in Arabic, but in phpmyadmin it says the the collation is latin1 swedish, which is is common thing I guess with phpmyadmin.
Now, what I really need to know is:
How to turn this funny encoding to UTF8.
I ran a query:
ALTER TABLE `table1` CHANGE `field1` `field1` TEXT CHARACTER SET latin1 NOT NULL ;
ALTER TABLE `table1` CHANGE `field1` `field1` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;
Now in phpmyadmin the fields have UTF8 besides them instead of latin1 swedish, but that funny looking text has not changed at all. :(
Any help will be appreciated.
