Need to change collation_database variable

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.



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

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?? :confused: