Need to use Chinese and English characters for redmine input (wiki, forum, issues, etc)

Added by Joe Price almost 5 years ago

Environment: redmine-2.5.2, mysql 5.1.70, OpenBSD 5.4, English

Example: I edit a wiki, paste in Chinese text (straight from google translate - I'm English). I see the Chinese correctly in the wiki input box. Hit preview, I see the Chinese correctly in the preview. Save it, now I see "??????" where the Chinese was.

To me, it seems like the data (the Chinese characters) are getting messed up when stored in the database which is why they seem fine in redmine until I save them.

Any suggestions on what the problem is?

I confess I am not familiar with internationalization in general :(

I know this is possible as I see it on this here at redimine.org.. I looked though the User Guide, FAQ, HowTos as well as searched. I'm probably not providing the right query somehow..

Thank you!

Replies (1)

RE: Need to use Chinese and English characters for redmine input (wkii, forum, issues, etc) - Added by Joe Price almost 5 years ago

OK, I think I see my problem:

mysql> show create database redmine;
+----------+--------------------------------------------------------------------+
| Database | Create Database                                                    |
+----------+--------------------------------------------------------------------+
| redmine  | CREATE DATABASE `redmine` /*!40100 DEFAULT CHARACTER SET latin1 */ |
+----------+--------------------------------------------------------------------+
1 row in set (0.00 sec)

Apparently, I didn't RTFM very well... http://www.redmine.org/projects/redmine/wiki/RedmineInstall states how to create the db:

CREATE DATABASE redmine CHARACTER SET utf8;

Now, converting the database from latin1 to utf8 is another issue, but surely out of scope as far redmine is concerned. On to MySQL docs...

(1-1/1)