Hi guys
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.
Thanks
Crabby
Hi guys
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.
Thanks
Crabby
Have you checked out the documentation?
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html
Also, use phpMyAdmin for your sanity unless you prefer the command line:
Hi,
Thanks for your reply
ok I’m really running out of ideas now
I’ve changed the MySQL server so that the charset is
collation_connection utf8_general_ci
collation_server utf8_general_ci
I’ve re-created the database so this variable is now set
collation_database utf8_general_ci
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??