MyBB Community Forums

I tried importing my MyBB 1.6 forum database to a localhost with phpmyadmin with UTF8, but it failed.

I checked my database but I don't have much experience with the backend of MySQL, so I want to make sure my character encoding is okay.

I entered command SHOW GLOBAL VARIABLES in the MySQL console:

MySQL Wrote:| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci

Latin1? Shouldn't everything be in UTF8? Should I change anything? I've set MyBB to use UTF8 as is the default...

Thanks

Some plugins etc. use latin1, you can go into your AdminCP > Tools & Maintance > UTF-Check and it'll check all the templates, then you can just click on the ones that aren't in UTF-8 and it'll convert them for you.