Project

General

Profile

Forums » Plugins »

Japanese Characters cannot use in Redmine

Added by Abdul Rahim Mohd Saad over 12 years ago

Hi,

I have a question regarding this issue.

My problem is when I attached a file with Japanese Characters such as "ご注意ください.xls"
Inside Redmine it become "???????????.xls"

It's not only attach file or folder, all comments all will be convertered to "????????"

What should I do?

Thanks.

Best Regards,
Abramosa


Replies (7)

RE: Japanese Characters cannot use in Redmine - Added by Costas Polychronopoulos over 12 years ago

It sounds like an encoding issue.

Check the encoding that the redmine database (MySQL?) has been created with. Then check the encoding used in the database.yml file. If these two coincide, Redmine will be able to read the garbled characters ok. However, if the encoding used does not support Japanese characters, your database (connecting directly to it) won't show them properly.

Hope it helps.

RE: Japanese Characters cannot use in Redmine - Added by Abdul Rahim Mohd Saad over 12 years ago

Hi Costas,

Thanks for your help.

What command inside database.yml that refer to encoding used?
Please refer my database.yml attached.

Location
***\BitNami Redmine Stack\apps\redmine\config

database.yml (944 Bytes) database.yml database.yml

RE: Japanese Characters cannot use in Redmine - Added by Costas Polychronopoulos over 12 years ago

It's the encoding property, which is set to utf8, as it seems.
Check that the database has also been created with the utf8 encoding.

RE: Japanese Characters cannot use in Redmine - Added by Abdul Rahim Mohd Saad over 12 years ago

Thank for reply..
So, do you have any idea?

Please help.

RE: Japanese Characters cannot use in Redmine - Added by Costas Polychronopoulos over 12 years ago

Hi Abdul! Have you checked the encoding of the MySQL database? Which one is it?
The encoding in the database.yml is the one the redmine application uses to connect to the database. Now you have to check if it's the same that is used on the database itself.

RE: Japanese Characters cannot use in Redmine - Added by Abdul Rahim Mohd Saad over 12 years ago

Hi thanks again.

The problem is I don't know where to find it.
What name or where is the setting?

I appreciate your help.

Best Regards,
Rahim Saad

RE: Japanese Characters cannot use in Redmine - Added by Costas Polychronopoulos over 12 years ago

You'll need to find a way to connect to your MySQL server and check the redmine database encoding. That's not Redmine specific, though.

BTW, you'd be better off if you didn't publish your database's passwords online.

    (1-7/7)