Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
the problem is that the mentiond collation doesn't return the expected result in the LIKE query
MariaDB [(none)]> SELECT "ss" LIKE "ß" COLLATE utf8mb4_unicode_ci; |
+-------------------------------------------+ |
| "ss" LIKE "ß" COLLATE utf8mb4_unicode_ci | |
+-------------------------------------------+ |
| 0 |
|
+-------------------------------------------+ |
1 row in set (0.00 sec) |
|
MariaDB [(none)]> SELECT "ss" = "ß" COLLATE utf8mb4_unicode_ci; |
+----------------------------------------+ |
| "ss" = "ß" COLLATE utf8mb4_unicode_ci | |
+----------------------------------------+ |
| 1 |
|
+----------------------------------------+ |
1 row in set (0.00 sec) |
it just happens with the ß character, other umlauts are fine
MariaDB [(none)]> SELECT "o" = "ö" COLLATE utf8mb4_unicode_ci; |
+---------------------------------------+ |
| "o" = "ö" COLLATE utf8mb4_unicode_ci | |
+---------------------------------------+ |
| 1 |
|
+---------------------------------------+ |
1 row in set (0.00 sec) |
|
MariaDB [(none)]> SELECT "o" LIKE "ö" COLLATE utf8mb4_unicode_ci; |
+------------------------------------------+ |
| "o" LIKE "ö" COLLATE utf8mb4_unicode_ci | |
+------------------------------------------+ |
| 1 |
|
+------------------------------------------+ |
1 row in set (0.00 sec) |
Also the expected behaviour on the general collation is fine
MariaDB [(none)]> SELECT "s" LIKE "ß" COLLATE utf8mb4_general_ci; |
+------------------------------------------+ |
| "s" LIKE "ß" COLLATE utf8mb4_general_ci | |
+------------------------------------------+ |
| 1 |
|
+------------------------------------------+ |
1 row in set (0.00 sec) |
|
MariaDB [(none)]> SELECT "s" = "ß" COLLATE utf8mb4_general_ci; |
+---------------------------------------+ |
| "s" = "ß" COLLATE utf8mb4_general_ci | |
+---------------------------------------+ |
| 1 |
|
+---------------------------------------+ |
1 row in set (0.00 sec) |