0006536: Mantis display a error infomation when create a chinese project

ID	Project	Category	View Status	Date Submitted	Last Update
0006536	mantisbt	administration	public	2005-12-26 09:37	2009-06-23 15:28

Reporter	mymsdn	Assigned To
Priority	normal	Severity	block	Reproducibility	always
Status	closed	Resolution	open
Product Version	1.0.0rc3
Fixed in Version	1.2.0rc1

Summary	0006536: 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' ??????????“??”???????????????????????????????????????????????????????????
Tags	No tags attached.
Attached Files	ErrorDetail.jpg (76,910 bytes) ErrorDetail.jpg (76,910 bytes)

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 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 2009-03-31 02:06 developer ~0021325	Tested fixed in git trunk with a UTF8 database.

APPLICATION ERROR 0000401
follow was the error detail infomation: