View Issue Details

WikiJump to Notes
IDProjectCategoryView StatusDate SubmittedLast Update
0007064mantisbtlocalizationpublic2006-05-09 04:372009-06-23 15:28
Reporterqyh Assigned Tosiebrand  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionfixed 
Product Version1.0.3 
Fixed in Version1.2.0rc1 
Summary0007064: [zh_TW] APPLICATION ERROR 0000401 Database query failed. Error received from database was #1406:
Description

Every time when I set language to chinese in Account Preferences, I can not report issue with chinese content. I will met an information like this :
"APPLICATION ERROR 0000401
Êý¾Ý¿â²éѯʧ°Ü¡£Êý¾Ý¿â·µ»ØµÄ´íÎóÐÅÏ¢ÊÇ£º#1406: Data too long for column 'description' at row 1 ²éѯ£ºINSERT INTO mantis_bug_text_table
( description, steps_to_reproduce, additional_information )
VALUES
( 'ºó', '',
'×óÓÒ' )

ÇëÔÚÄãµÄä¯ÀÀÆ÷ÖÐʹÓá°ºóÍË¡±°´Å¥À´·µ»Øµ½ÉÏÒ»Ò³Ã棬ÕâÑùÄú¿ÉÒÔÕÒµ½·¢ÉúÁËʲôÎÊÌâ»òÕß½øÐбðµÄ²Ù×÷£»Äú»¹¿ÉÒÔµã»÷µ¼º½À¸ÖеÄÑ¡ÏîÖ±½ÓÌøתµ½Ò»¸öеÄÇø¶Î¡£"

The important thing is that I set values to ( description, steps_to_reproduce, additional_information ) as ( 'Ç°', 'ºó','×óÓÒ' ). It feedback as ( 'ºó', '',
'×óÓÒ' ).

Only one time after I set language to english in Account Preferences, I recieve an error information as "Database query failed. Error received from database was #1406: Data too long for column 'description' at row 1 for the query: INSERT INTO mantis_bug_text_table
( description, steps_to_reproduce, additional_information )
VALUES
( '后', '',
'塤¦å³' )" , with the same input.

Additional Information

The configuration of my server is :
windows XP, IIS5.1, MySQL 5.0.20, php5.1.2.

I insert and select some chinese word of gb2312 in my MySQL 5.0.20.It works correctly.

TagsNo tags attached.

Activities

qyh

qyh

2006-05-09 23:34

reporter   ~0012802

I made a mistake in the sentence"The important thing is that I set values to ( description, steps_to_reproduce, additional_information ) as ( 'Ç°', 'ºó','×óÓÒ' ). It feedback as ( 'ºó', '',
'×óÓÒ' ).
".
I check the database and tables. There's no mistake in the sequence of access.
qyh

qyh

2006-05-10 01:45

reporter   ~0012803

I can input chinese when I replace MySQL 5.0.20 with MySQL 4.1.19.
siebrand

siebrand

2008-09-10 17:09

developer   ~0019360

Can you please let us know if this can still be reproduced using Mantis 1.2.0a2? I assume this has been resolved now that Mantis uses UTF-8 encoding. You can work on the localisation of Mantis in Chinese localisations in http://translatewiki.net. Your help is appreciated!
siebrand

siebrand

2009-03-30 18:47

developer   ~0021306

Tested working with git trunk. I took some content off the zh.wikipedia.org main page, and used it in the summary and description fields.