330430 - Data too long for column 'thetext' when inserting multi-byte characters

Status: RESOLVED DUPLICATE of bug 304550

(Bugzilla :: Creating/Changing Bugs, defect)

Description

[frank]

User-Agent:       Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322)
Build Identifier: bugzilla-2.20.1

DBD::mysql::st execute failed: Data too long for column 'thetext' at row 1 [for Statement "INSERT INTO longdescs (bug_id, who, bug_when, thetext, isprivate) 
         VALUES (12, '1', '2006-03-14 16:31:49', '***********************************************************************\nFatal NI connect error 12514, connecting to:\n (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xiangzh)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=DMSTEST)(CID=(PROGRAM=C:\\Program Files\\Quest Software\\TOAD\\TOAD.exe)(HOST=XIANGZH)(USER=hpadmin))))\n\n  VERSION INFORMATION:\n	TNS for 32-bit Windows: Version 9.2.0.1.0 - Production\n	Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production\n  Time: 29-12ÔÂ-2005 22:35:55\n  Tracing not turned on.\n  Tns error struct:\n    nr err code: 0\n    ns main err code: 12564\n    TNS-12564: TNS£º¾Ü¾øÁ¬½Ó\n    ns secondary err code: 0\n    nt main err code: 0\n    nt secondary err code: 0\n    nt OS err code: 0', 0)"] at Bugzilla/DB.pm line 84
	Bugzilla::DB::SendSQL('INSERT INTO longdescs (bug_id, who, bug_when, thetext, ispriv...') called at C:/bugzilla-2.20.1/post_bug.cgi line 405

For help, please send mail to the webmaster ([e-mail]), giving this error message and the time and date of the error. 


Reproducible: Always

Steps to Reproduce:
1.enter to create a new bug
2.input a long sentences
3.submit the bug

Actual Results:  
cannot create the new bug

Expected Results:  
create the bug successfully

sometimes, even I input a short description of the bug(In chinese language words), it also prompts me error.
I am running the bugzilla-2.20.1 on Windows XP + sp2, the database is mysql 5.0.18. Apache httpd's version is 2.0.55.

Comment 1

[frank]

when I execute the insert statement through the mysql client, it works fine, but when I submit these words through the bugzilla, it always shows me error.

Comment 2

[frank]

could anybody reply this issue?

Comment 3

[Max Kanat-Alexander]

What version of DBD::mysql are you using? Looks like you're putting in some non-English characters into the database. Do you have the UTF-8 parameter turned on in Bugzilla?

Also:

(In reply to comment #2)
> could anybody reply this issue?

Bugzilla is for reporting bugs, not for getting support. If you want support, see: http://www.bugzilla.org/support/

Comment 4

[frank]

yes, there are some non-English words.

Checking for      DBD::mysql (v2.9003) ok: found v3.0002.
by the way, how to turn on the UTF-8 parameters encoding?

Comment 5

[Marc Schumann [:Wurblzap]]

I'd say a multi-byte character counts occupies as many DB-characters as it is bytes wide. With Chinese, which iirc uses 4 Byte per character throughout, this probably means that all text entered looks to be four times as long.

It seems to me that we need to tell the database somehow that we want to use UTF-8...

Comment 6

[Max Kanat-Alexander]

I suspect this is a dup of bug 304550. If bug 304550 gets fixed and this is still a problem, let us know by reopening this bug.

*** This bug has been marked as a duplicate of 304550 ***