How do I change the collation_database varible from latin1_swedish_ci to utf8_general_ci?
I've already managed to change the collation_connection and collation_server
Any help would be much appreciated.
Have you checked out the documentation?
Also, use phpMyAdmin for your sanity unless you prefer the command line:
Thanks for your reply
ok I'm really running out of ideas now
I've changed the MySQL server so that the charset is
I've re-created the database so this variable is now set
I've changed the fields in my table to utf8_general_ci collation
And I'm still getting odd chars particulary Â (for a mid point) when insert data?
What else can I try??
This topic is now archived. It is frozen and cannot be changed in any way.