• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF | Character Problem?

Jake Bunce

XenForo moderator
Staff member
#5
Did you import from another forum application?

I agree with Brogan. Check the collations in your database. You can check the collations using a program like phpmyadmin which many hosts preinstall for you. Once inside of phpmyadmin you can view the collations. All tables and fields should be utf8_general_ci:

Screen shot 2011-12-28 at 2.00.27 AM.png

Screen shot 2011-12-28 at 2.01.30 AM.png

Also try rebuilding your forum info:

Admin CP -> Tools -> Rebuild Caches -> Rebuild Forum Information
 

Brogan

XenForo moderator
Staff member
#6
Run this command in phpMyAdmin for each table.

ALTER TABLE name_of_table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

Change the red text to the name of each table in turn.

Then change the collation for the database itself using the Operations tab.
 

Jake Bunce

XenForo moderator
Staff member
#7
#8
Did you import from another forum application?

I agree with Brogan. Check the collations in your database. You can check the collations using a program like phpmyadmin which many hosts preinstall for you. Once inside of phpmyadmin you can view the collations. All tables and fields should be utf8_general_ci:

View attachment 23014

View attachment 23015

Also try rebuilding your forum info:

Admin CP -> Tools -> Rebuild Caches -> Rebuild Forum Information
the menu does not appear "Rebuild Caches" :S