Bug #7654 Mysql 4.1 truncates utf8 text
Submitted: 4 Jan 2005 10:23 Modified: 4 Feb 2005 16:12
Reporter: Alexander Lockshyn Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.7 OS:Linux (Gentoo linux 2004'3)
Assigned to: CPU Architecture:Any

[4 Jan 2005 10:23] Alexander Lockshyn
When text in UTF8 encoding is inserted to the MyISAM text fields (mediumtext, longtext, etc) mysql truncates it without reporting any errors. I tried to insert the same text to mysql 3.23 and it inserted correctly.
At the same time texts without unicode charecters are not truncated by MySQL 4.1.7

How to repeat:
Just insert long (more then ~500kb) texts with cyrilic (or any other unicode charecters) to the LONGTEXT fields.
[4 Jan 2005 16:12] MySQL Verification Team

Thank you for the report. Your bug report doesn't have enough info to reproduce it. It works like a charm for me.
Please describe your actions more detailed.
How did you load data?
Did you get any warnings?
Check also max_alowed_packet value.
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[23 Mar 2006 13:35] Gaurav Mehta
We are using tomcat 5.0 and mysql4.1.7 and java5.0 , some times thedata sent for insertion in Table got Truncates even when data lengthis less and in database table, field data type is long text. Thisproblem comes occasionally but not reproduable easily as it happensrarely. Please advice us what can be the cause and the solution forit.