How to convert database to utf8

[teddy_2007]

The database I create have collation is swedish_general_ci how to convert to utf8_general_ci.

I don't know why I create category in Joomla such as name "ư" then joomla show "?" please help me.

Thanks

[hofmax]

I've been looking for an answer to that as well. I didn't really come across a general switch in phpmyadmin for charset. So what you can do is dump your entire db, open it in your favourite editor and search all charset entries in the db dump and replace swedish_general_ci with utf8_general_ci. Then reimport. For me this method worked.


edit I am not sure at all how Joomla works but it should actually put all your db test in either htmlspecialchars() or htmlentities() so that these characters should be converted to the special characters automatically i.e. ü in the db would become
ü . If it's not doing that you could convert all your db entries to special chars before they hit the view but I doubt that should be necessary or Joomla is really pathetic which I doubt.