WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. Vtor Maia
    Member
    Posted 3 years ago #

    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

    Vítor

  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.

    http://codex.wordpress.org/Converting_Database_Character_Sets

  3. Vtor Maia
    Member
    Posted 3 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', '');

    for

    /** 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
    Member
    Posted 3 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
    Member
    Posted 3 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:

    CREATE DATABASE dbname DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

    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
    Member
    Posted 3 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
    Member
    Posted 3 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

Tags