Database variables : Problem different char set

[Luc Trude]

I am trying to have my database be totally encoding in utf8 by default instead of the latin1

by searching on the web I found some strings which got me to change some of the values as you see below. What can I do to change all of them to utf8.

By reading different posts it does seem that having a unified approach simplifies things. I have problems with french accent characters in a contact list I am using with a program called Maxpro Maxbulk Mailer. They have everything running in utf8 it seems so the problem has to be the mysql database. What do you think? WHat else should I check? What can I do?


character_set_client latin1
character_set_connection latin1
character_set_database utf8
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/local/nf/mysql-5.0/share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database ut8_general_ci
collation_server latin1_swedish_ci