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.

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