Relationship Graph

View IssueDependency GraphShow Summary
Relationship Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0006536mantisbtadministrationpublic2005-12-26 09:372009-06-23 15:28
Reportermymsdn Assigned To 
PrioritynormalSeverityblockReproducibilityalways
Status closedResolutionopen 
Product Version1.0.0rc3 
Fixed in Version1.2.0rc1 
Summary0006536: Mantis display a error infomation when create a chinese project
Description

APPLICATION ERROR 0000401
follow was the error detail infomation:

????????????????????#1267: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' ???SELECT COUNT(*)
FROM mantis_project_table
WHERE name='??ERP'

??????????“??”???????????????????????????????????????????????????????????

TagsNo tags attached.
Attached Files
ErrorDetail.jpg (76,910 bytes)   
ErrorDetail.jpg (76,910 bytes)   

Relationships

Relationship GraphDependency Graph
related to 0004084 closedsiebrand [all lang] Use UTF-8 codepage 

Activities

ryandesign

ryandesign

2005-12-29 06:06

reporter   ~0011848

Perhaps you should convert your database tables from latin1_swedish to utf8_general, and then log in to Mantis with the utf8 languages instead of, for example, the gb2312 Chinese language file.

In the config file, you may want to remove the non-utf8 languages from $g_language_choices_arr, modify $g_language_auto_map so it uses the utf8 languages, and possibly create utf8 variants of any existing languages (like english) that you may still want to use.

See also 0004084.
siebrand

siebrand

2008-09-10 18:09

developer   ~0019374

Please provide feedback testing on Mantis 1.2.x with a UFT-8 encoded database. All localisations are UFT-8 by default.
siebrand

siebrand

2009-03-31 02:06

developer   ~0021325

Tested fixed in git trunk with a UTF8 database.