Bug #7397 MySQLCC TEXT editor drops characters
Submitted: 18 Dec 2004 4:26 Modified: 18 Dec 2004 8:43
Reporter: Szczepan Holyszewski Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQLCC Severity:S2 (Serious)
Version:0.9.4 OS:Linux (Fedora Core 3)
Assigned to: CPU Architecture:Any

[18 Dec 2004 4:26] Szczepan Holyszewski 
Description:
MySQLCC built-in editor for TEXT fields drops characters from the end of the text if national characters are present. For each national character in the text, one character is dropped from the end. Command line query shows that the truncation occurs while storing the text back into the table, not while extracting it for editing. MEDIUMTEXT and LONGTEXT are affected too.

I gave it 'Serious' severity for it causes data loss.

How to repeat:
Create a database, create a table with a TEXT field, insert a record, edit the TEXT field, enter 9876543210 (no newline at the end), apply. Edit again, enter five national characters (like a-ogonek) before digits, apply again. Edit again (or query from command line) to see the value truncated after digit 5.

Suggested fix:
Perhaps somewhere the number of _characters_ in the text is improperly used instead of the number of _bytes_ in the multibyte encoding representation.
[18 Dec 2004 8:43] MySQL Verification Team 
Hi,

Thank you for the report, but MySQL Control Center is not longer under development.
Take a look at another GUI tools like MySQL Query Browser and MySQL Administrator.