Bug #76380 Text truncation message when inserting non-english characters on Inserts tab
Submitted: 18 Mar 2015 22:22 Modified: 15 May 2015 2:33
Reporter: Sergio Bobillier Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:6.2.5.0 OS:Linux (Ubuntu 14.04)
Assigned to: CPU Architecture:Any

[18 Mar 2015 22:22] Sergio Bobillier
Description:
When inserting non-english characters in the "Inserts" tab in an EER diagram MySQL Workbench says that the text was truncated due to it's length.

It happens with any non-english character, including high unicode characters like Chinese Ideograms.

How to repeat:
1. Create a new Model
2. Add a EER Diagram
3. Add a table with a VARCHAR field.
4. Go to the Inserts tab and add a new row.
5. In the VARCHAR field add a string with a non-english character, for example:

    Español or 日本語

    Note: It happens when typing on the keyboard or when pasting the text
    from the clipboard.

6. An error messages pops-up with this message:

    Text Truncation
    Inserted data has been truncated as the
    control's limit was reached. Please use the value
    editor instead for editing such large text data.
[18 Mar 2015 23:43] MySQL Verification Team
Message

Attachment: truncation message.png (image/png, text), 178.58 KiB.

[18 Mar 2015 23:44] MySQL Verification Team
Thank you for the bug report.
[19 Mar 2015 8:28] Mike Lischke
What's the problem here? The message is a note to you to tell that you cannot use the inline editor but use the value editor (available via the context menu). This is not a bug but a feature to allow inserting longer text.
[19 Mar 2015 14:17] Sergio Bobillier
The problem is that MySQL Workbench is claiming that the text is too long for the inline editor but the text is far below the length of the field and I do not think that 7 characters in the case of Español or 3 characters in the case of 日本語 is too much.

The problem is that the input doesn't accept non-english characters (high unicode characters). I don't know if this is by design but I bet it is not. If I had to guess I would say that there is something wrong with the routine that checks the length of the text. Maybe it doesn't handle multibyte characters right.
[21 Apr 2015 1:07] Orlando Leite
I have to problem pasting or typing the value 'Saída'.
[15 May 2015 2:33] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL Workbench 6.3.4 release, and here's the changelog entry:

In the EER diagram editor, adding non-English characters, including high
Unicode characters, into table's VARCHAR field would assume the text was
too large to fit.

Thank you for the bug report.
[15 May 2015 7:08] Rumata Estorsky
Source of this bug: https://bugs.mysql.com/bug.php?id=66031