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

XF | Character Problem?

Discussion in 'Troubleshooting and Problems' started by rodrigotello, Dec 28, 2011.

  1. rodrigotello

    rodrigotello New Member

    That's problem..! Turkish Character Problem...what can I do?

  2. Brogan

    Brogan XenForo Moderator Staff Member

    What Collation are your tables and database set to?

    Try setting them to utf8_general_ci.
  3. rodrigotello

    rodrigotello New Member

    I left that field blank :S
  4. rodrigotello

    rodrigotello New Member

    exc. me... how to set? :(
  5. Jake Bunce

    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
  6. Brogan

    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.
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    If it comes to that then you can use this script to do all tables at once:

    Brogan likes this.
  8. rodrigotello

    rodrigotello New Member

    the menu does not appear "Rebuild Caches" :S
  9. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

  10. rodrigotello

    rodrigotello New Member

    How to re-balance the entire system must be in UTF8.... ?

Share This Page