Hi!
Can anyone tell me if my database and all the tables in there should have the same collation?

My database is utf8_general_ci and some of my tables are also utf8_general_ci, but some other tables are latin1_swedish_ci.

Does this matter?
Should I convert the latin ones to utf8?
I tested converting 1 table from latin to utf8 and it doesn't seem to have broken anything but I did notice the columns in the table are still latin!

Everything has been working fine for months but the other day someone signed up from Sweden and there was a strange character in his address. Not a major problem as I was bale to change it manually but I'm wondering if converting all the tables to utf8 would solve this?

I'm pretty well and truly out of my depth here and am looking for advice