Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL), 10.2(EOL)
-
None
Description
mysql> SELECT CAST(CONVERT('1IJ3' USING ucs2) AS SIGNED);
|
+--------------------------------------------+
|
| CAST(CONVERT('1IJ3' USING ucs2) AS SIGNED) |
|
+--------------------------------------------+
|
| 123 |
|
+--------------------------------------------+
|
1 row in set (0.00 sec)
|
The above result is wrong. The expected result is 1 with a warning.
The character:
U+0132 LATIN CAPITAL LIGATURE IJ
|
is misinterpreted as
U+0032 DIGIT TWO
|