My MU site does not like the latin1_swedish_ci charset (12 posts)

  1. Vtor Maia
    Posted 4 years ago #


    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


  2. 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.


  3. Vtor Maia
    Posted 4 years ago #

    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.

  4. 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.

  5. Vtor Maia
    Posted 4 years ago #

    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?

  6. Yes.

  7. Also this db issue is not multisite specific.

  8. James Collins
    Posted 4 years ago #

    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.

  9. Or ... On your extant DB

    ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

  10. Vtor Maia
    Posted 4 years ago #

    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

  11. Vtor Maia
    Posted 4 years ago #

    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

  12. You can try posting at jobs.WordPress.net

Topic Closed

This topic has been closed to new replies.

About this Topic