Bug #71564 Combining characters in mysql monitor

Submitted:	3 Feb 2014 11:34	Modified:	7 Feb 2014 18:16
Reporter:	Daniël van Eeden	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S3 (Non-critical)
Version:	5.6.15	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
The width of a column in a result table is not calculated correctly if there are combining characters.

Related to Bug #17939 and Bug #71563

How to repeat:
mysql> SELECT name, HEX(name), LENGTH(name), CHAR_LENGTH(name) FROM t1;
+----------+------------------+--------------+-------------------+
| name     | HEX(name)        | LENGTH(name) | CHAR_LENGTH(name) |
+----------+------------------+--------------+-------------------+
| Daniël   | 44616E69C3AB6C   |            7 |                 6 |
| Daniël  | 44616E6965CC886C |            8 |                 7 |
+----------+------------------+--------------+-------------------+
2 rows in set (0.00 sec)

Suggested fix:
calculate string length after unicode normalization

I posted this
http://bugs.mysql.com/bug.php?id=71625

Thank you for the report.

Verified as described. However, I think reason is the same bug #71563

Page generated in 0.053 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.