Thread

hey expressionengineers,
i stumbled upon a problem in the forum module.
some people need to write chinese characters and are not able to.
i thought installing the expressionengine system with utf-8 would allow the forum to use chinese characters as well but somehow it doesn`t. any clue where i can change the forum module to support chinese characters?
thanks for help,
martin

Hi, Martin.

Can you post any of it here, for instance? I’m not that familiar with Chinese characters and the forum module.

hey sue,
these are some of them:
䮅

i went into phpmyadmin and had a look into the forum tables structure and saw that for example

exp_forum_posts has as collation latin1_swedish_ci

which is kinda strange as i installed ee to support utf-8 !?
do i need to change every forum table`s structure collation? are there impacts when i do this`as the forum is in use allready.
is this a bug which is fixed in a news forum module version?

thanks for help.

In EE 2.1.3 I can sort of replicate the problem

http://eehowto.com/index.php/forums/viewthread/20/

For instance, the first one shows, but the other two do not.

I’ll need to test on 2.2.1 in a bit, but wanted to update the thread.

hello sue,
thanks for your update.
did you read my last response regarding the mysql collation of the forum module tables although ee was installed in utf.
how can i proceed from there? isn`t this just a encoding issue?

thanks.

Hi, mtin79 -

EE uses the database as you set it up; EE itself is UTF-8 but it does not force a database collation.

If you make a dev copy with the database collation set to utf-8, does that alleviate the problem?

Thank you!

hello lisa and thanks for your reply!
unfortunatelly i don`t how to make a “dev copy” of the database (what`s the procedure and if there are any risks for content which is allready in there).
could you provide me a little more details?
thanks a lot!

Hi, mtin79.

You’d take your existing database, export it using something like PHPMyAdmin, and create a local install of EE.

Are you on a Windows machine or a Mac? I use MAMP for the Mac and WAMP for the PC. There would be no risk to the content, since you’d be working with a *copy* of your real database.

Does that help?

so in the end i changed all forum database tables to the utf-8 collation and it worked.

took me a while to research for possible problems which might occur during the change. stack overflow was a big help on that.

glad you got this figured out, mtin79 - and thank you for posting the solution.

If you have any other questions, please start a new thread, thank you.