编码MySQL的问题

Question

I get small boxes instead of swedish character å, ä and ö, despite that I'm using UTF-8 everywhere I can think of! I saved the files with UTF-8 without BOM from notepad and the HTML page has meta charset="utf-8" and I changed the table in the database to UTF8_swedish_ci. What have I missed? Preciate some help! Thanks!

EDIT: Would it be better to use latin and save all files in latin instead of UTF8? But could I still use the meta charset="utf-8" in the HTML head?

Answer 1

Check what collation you using in MySQL connection? Set right one.

you can change collation for current connection using query: set names utf8 collate utf8_swedish_ci")