Support » Networking WordPress » My MU site does not like the latin1_swedish_ci charset

  • Hello,

    I have i big problem in my network, and i need your help to find the best solution.

    The main language of my network is Portuguese.

    I enable the multi site without problems and everything runs great.

    BUT ,

    There is a problem that i don’t now how to resolve.

    I have a lot of tables in the MSQL database with the latin1_swedish_ci charset, and i have a lots of problems with this because the Portuguese characters prints very strange in some plugins and rss feeds for example:

    “Os plugins Premium apenas estÃ?��Ã?�Ã?£o disponÃ?��Ã?�Ã? veis para os Membros Pro . Porque nÃ?��Ã?�Ã?£o te tornas agora um Membro Pro?”

    This is not Portuguese!?

    How can i resolve this problem?

    Thank you


Viewing 11 replies - 1 through 11 (of 11 total)
  • Since the release of WordPress 2.2 the character set has been set by default to UTF-8 and the users that come from previously versions of WordPress, may have some problems with the old Latin1 character set and the new default UTF-8 character set.

    This article it’s so difficult for me 🙁

    In a fresh installation of wordpress if i setup the:

    /** O “Database Collate type”. Se tem dúvidas não mude. */
    define(‘DB_COLLATE’, ”);


    /** O “Database Collate type”. Se tem dúvidas não mude. */
    define(‘DB_COLLATE’, ‘utf8_general_ci’);

    All this problems are resolved?

    When i install the wordpress i left the define(‘DB_COLLATE’, ”); blank.

    Yeah, the problem is you can’t just change the define statement. You have to ALSO change your database.

    It’s not easy, I’m afraid, and I don’t know of any actively supported plugins that can do it.

    Sorry, left me now if i understand well.

    I’m in the beginning of my WordPress MU foundation.

    If i re-install all again, defining the “define(‘DB_COLLATE’, ‘utf8_general_ci’); ” i skip this charset problem?


    Andrea Rennick


    Customer Care at Copyblogger Media and Studiopress

    Also this db issue is not multisite specific.

    The problem with that is that not all plugins (that create their own db table) will obey that DB_COLLATE define.

    The best bet is to reinstall from scratch (including deleting your MySQL database). Then when creating a new MySQL database, set its default character set to UTF8 as well:


    That way any table created in that database should be created as UTF8.

    Or … On your extant DB

    ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

    I’m screwed and frustrated 🙁

    I reinstall all my site. Setup the correct CHARACTER SET utf8 COLLATE utf8_general_ci.

    99,9% of my tables have now the COLLATE utf8_general_ci.

    Unfortunately, one of the most important tables, the wp_user_activity use the latin1_swedish_ci :(!

    In the rss feed for users activity exist a lot of strange characters.

    What to do now?

    Convert only one table? this is possible?

    Thank you

    Do yo now anybody who can accomplish that?

    I pay in €/$.

    This site is a important investment for me and for my region.

    Thank you

    You can try posting at

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘My MU site does not like the latin1_swedish_ci charset’ is closed to new replies.