XF | Character Problem?

Brogan

XenForo moderator
Staff member
What Collation are your tables and database set to?

Try setting them to utf8_general_ci.
 

Jake Bunce

XenForo moderator
Staff member
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
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

rodrigotello

New member
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
 
Top