Using the latest version of MySql. I created a database, it defaulted to Latin1_Swedish, and just noticed that the 'mysql' database also has Latin1_Swedish. Only the information_schema has a collation of utf8_general_ci. Should I be changing my database to utf8? And if so, how?
There are a few options to change from the default latin1_swedish setting
You can compile mysql to have a default character set of utf8
You can change the defaults within the my.cnf file, or at runtime of the mysql server.
You can also specify the characterset when creating your databases.
Whether you should or not, is your call.
Here's some docs on the topic, which might be worth having a look through.