Mantis Bug Tracker
 
Main | My View | View Issues | Change Log | Roadmap | Wiki | ManTweet | Repositories
  

View Issue Details [ Jump to Notes ] [ Wiki ] [ Issue History ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0011644mantisbtdocumentationpublic2010-03-12 01:422010-03-31 03:33
Reportersquarebox 
Assigned Tojreese 
PriorityhighSeverityblockReproducibilitysometimes
StatusresolvedResolutionno change required 
PlatformOSOS Version
Product Version1.2.0 
Target VersionFixed in Version 
Summary0011644: Instructions for setting up sql db to use UTF-8 collation
DescriptionUsers of non-english charsets are unable to see their native language on fresh install of Mantis because of the db collation setting. Adding instructions or a footnote to the installation instructions would help those users and stop the associated forum posts and bug reports.

discussion and various fixes can be found here in the forums

http://www.mantisbt.org/forums/viewtopic.php?f=2&t=4936 [^]
Additional Informationobvious cases for this are japanese, korean and chinese
TagsNo tags attached.
Attached Files

- Relationships
child of 0004350closeddhx FAQ 

-  Notes
User avatar (0024846)
jreese (administrator)
2010-03-22 14:36

 If you're talking about fresh installations, the problem is not caused by MantisBT. Instead, the person creating the database should be setting the default collation for the database to utf8 before installation, so that when MantisBT creates tables the database will automatically set the table/field collations based on the database's default setting.

If you need to convert an existing database/table/field collations to utf8, there are plenty of resources on Google for how to go about this.
User avatar (0024856)
squarebox (reporter)
2010-03-22 21:16
edited on: 2010-03-23 01:02

 There was alot of people running into this issue so i had suggested on the forums to add this to the mantis install doc as a gotcha even though it has nothing to do with mantis. Then Atrol suggested i create a bug report so that it could be tracked.

Also requiring first time East-asian adopters of mantis to have to look up on google to get the mantis installed is going to prevent alot of people from ever installing mantis. Also, I'd also like to point out that alot technical answers are typically provided in English, and the resources available to the Asian language community is particularly lacking.

I'm not saying we include various instructions for the different dbs out there, but just a friendly note that says "hey, you may run into issues if your language isn't english, but can be remedied by setting your db collation to utf-8 before installation. Please refer to your db documentation for instructions on how to do so."
User avatar (0024914)
squarebox (reporter)
2010-03-28 20:50

 Could this be tagged onto the following bugnote, as it seems to be better aligned for a FAQ since this question has come up numerous times.

0004350

- Issue History
Date Modified Username Field Change
2010-03-12 01:42 squarebox New Issue
2010-03-22 14:36 jreese Note Added: 0024846
2010-03-22 14:36 jreese Status new => resolved
2010-03-22 14:36 jreese Resolution open => no change required
2010-03-22 14:36 jreese Assigned To => jreese
2010-03-22 21:16 squarebox Note Added: 0024856
2010-03-23 01:02 squarebox Note Edited: 0024856 View Revisions
2010-03-28 20:50 squarebox Note Added: 0024914
2010-03-31 03:33 atrol Relationship added child of 0004350

MantisBT 1.2.2 git master-1.2.x[^]
Copyright © 2000 - 2010 MantisBT Group
Time: 0.2040 seconds.
memory usage: 1,953 KB
Powered by Mantis Bugtracker