Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11, 11.4, 11.8
-
None
-
None
-
Q4/2026 Server Maintenance
Description
On 10.6 JSON_UNQUOTE returns the same collation as JSON_EXTRACT:
SELECT COLLATION((JSON_EXTRACT('{"a":"Test"}','$.a'))) AS result;
|
+--------------------+
|
| result |
|
+--------------------+
|
| utf8mb3_general_ci |
|
+--------------------+
|
|
|
SELECT COLLATION(JSON_UNQUOTE(JSON_EXTRACT('{"a":"Test"}','$.a'))) AS result;
|
+--------------------+
|
| result |
|
+--------------------+
|
| utf8mb3_general_ci |
|
+--------------------+
|
But from 10.11 on it returns utf8mb4_bin instead, regardless of default character set and collation settings:
SELECT COLLATION((JSON_EXTRACT('{"a":"BOND"}','$.a'))) AS result;
|
|
|
+--------------------+
|
| result |
|
+--------------------+
|
| utf8mb3_general_ci |
|
+--------------------+
|
|
|
SELECT COLLATION(JSON_UNQUOTE(JSON_EXTRACT('{"a":"Test"}','$.a'))) AS result;
|
+--------------+
|
| result |
|
+--------------+
|
| utf8mb4_bin |
|
+--------------+
|
Attachments
Issue Links
- is caused by
-
-
- Closed
-
