View Issue Details

IDProjectCategoryView StatusLast Update
0008956mantisbtupgradepublic2017-01-31 04:05
Reporterpaull Assigned Toatrol  
PrioritynormalSeverityblockReproducibilityhave not tried
Status closedResolutionno change required 
Product Version1.1.1 
Summary0008956: Japanese text becomes garbled on upgrade
Description

Upgrading 1.0.3 which worked perfectly to 1.1.1 causes all Japanese text (previously entered text (becomes garbled) as well as newly entered text (becomes question marks) to be unreadable.

The regular interface is displayed correctly in Japanese, just the data being pulled in from the database. The data in the database is the same for both versions and it continues to show up as garbled.

Additional Information

Will stay at 1.0.3 until this is resolved.

TagsNo tags attached.

Activities

ryandesign

ryandesign

2008-03-12 04:03

reporter   ~0017318

Did you convert the data in your database from whatever charset it was using before to UTF-8? I think you need to manually do that during the pre-1.1.0-to-1.1.0 upgrade, though I can't find documentation on that right now...

paull

paull

2008-03-12 04:17

reporter   ~0017320

Thanks for the response.

I tried that and just tried again (with a subset of the tables, like the table that contains the note text, using phpmyadmin.

Any existing text was changed to mojibake. Text that I added manually in phpmyadmin showed up fine.

When viewing the text in phpmyadmin, it always shows up garbled, however was always displayed correctly in 1.0.3. The collation of the database is latin1_swedish_ci.

ryandesign

ryandesign

2008-03-12 04:24

reporter   ~0017321

Ok, so you have Japanese characters in some charset shoved into fields of latin1_swedish_ci collation. You will have to figure out how to correct this so that you have correct utf8 characters in fields of a utf8 collation. Then Mantis >= 1.1 will work correctly, and also phpMyAdmin will show the data correctly. It has been a few years since I last had to do such a conversion so I'm not sure what the best way is anymore.

paull

paull

2008-03-12 04:35

reporter   ~0017322

Thanks for the information.

Is there an explanation as to why it broke?

nurikabe

nurikabe

2008-04-28 13:48

reporter   ~0017712

paull, probably you have EUC-JP encoded Japanese stored as a latin1_swedish_ci collation. Convert that into UTF-8 and it should work.

Mantis dropped support for outdated Japanese encodings which is why it appears broken.

atrol

atrol

2017-01-18 13:02

developer   ~0055209

As mentioned by nurikabe

Convert that into UTF-8 and it should work

We are resolving this issue as "no change required", because it was reported against an old version of MantisBT which is no longer supported.

We recommend that you upgrade to the latest stable version [1]; if after doing so the problem still exists, do not hesitate to reopen the issue.

[1] http://www.mantisbt.org/download.php