My MU site does not like the latin1_swedish_ci charset

  • Vítor Maia

    (@vmaia)


    13 years, 4 months 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

Viewing 11 replies - 1 through 11 (of 11 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years, 4 months ago

    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

    Thread Starter Vítor Maia

    (@vmaia)

    13 years, 4 months 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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years, 4 months ago

    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.

    Thread Starter Vítor Maia

    (@vmaia)

    13 years, 4 months 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?

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years, 4 months ago

    Yes.

    Andrea Rennick

    (@andrea_r)

    13 years, 4 months ago

    Also this db issue is not multisite specific.

    James Collins

    (@jamescollins)

    13 years, 4 months 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.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years, 4 months ago

    Or … On your extant DB

    ALTER DATABASE dbname CHARACTER SET utf8 COLLATE utf8_general_ci;

    Thread Starter Vítor Maia

    (@vmaia)

    13 years, 4 months 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

    Thread Starter Vítor Maia

    (@vmaia)

    13 years, 4 months 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

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    🏳️‍🌈 Advisor and Activist

    13 years, 4 months ago

    You can try posting at jobs.WordPress.net

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.

Tags