Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.21
-
None
-
Seen on both OS X 10.9 and Ubuntu 14.04
-
10.2.11
Description
Possibly related to MDEV-461.
When calling column_create with names set to utf8, one can successfully
encode an emoji that takes 4 bytes in utf-8:
adamj@localhost [1]> set names utf8;
|
adamj@localhost [2]> select column_json(column_create('��', 1));
|
+---------------------------------------+
|
| column_json(column_create('��', 1)) |
|
+---------------------------------------+
|
| {"��":1} |
|
+---------------------------------------+
|
However if the connection is set to utf8mb4 this actually fails,
counter-intuitively:
adamj@localhost [3]> set names utf8mb4;
|
adamj@localhost [4]> select column_json(column_create('��', 1));
|
+------------------------------------+
|
| column_json(column_create('?', 1)) |
|
+------------------------------------+
|
| {"?":1} |
|
+------------------------------------+
|
|
|
adamj@localhost [5]> select column_list(column_create('��', 1));
|
+------------------------------------+
|
| column_list(column_create('?', 1)) |
|
+------------------------------------+
|
| `?` |
|
+------------------------------------+
|
Other unicode characters work fine though:
adamj@localhost [6]> select column_list(column_create('❤', 1));
|
+--------------------------------------+
|
| column_list(column_create('❤', 1)) |
|
+--------------------------------------+
|
| `❤` |
|
+--------------------------------------+
|