mysql> SET collation_connection = utf8_unicode_ci;
|
Query OK, 0 rows affected (0.00 sec)
|
|
mysql> SELECT '\%b' LIKE '%\%';
|
+------------------+
|
| '\%b' LIKE '%\%' |
|
+------------------+
|
| 1 |
|
+------------------+
|
1 row in set (0.00 sec)
|
|
mysql> SET collation_connection = utf8_general_ci;
|
Query OK, 0 rows affected (0.00 sec)
|
|
mysql> SELECT '\%b' LIKE '%\%';
|
+------------------+
|
| '\%b' LIKE '%\%' |
|
+------------------+
|
| 0 |
|
+------------------+
|
1 row in set (0.00 sec)
|
|
mysql> SET collation_connection = utf8mb4_unicode_ci;
|
Query OK, 0 rows affected (0.00 sec)
|
|
mysql> SELECT '\%b' LIKE '%\%';
|
+------------------+
|
| '\%b' LIKE '%\%' |
|
+------------------+
|
| 1 |
|
+------------------+
|
1 row in set (0.00 sec)
|
|
mysql> SET collation_connection = utf8mb4_general_ci;
|
Query OK, 0 rows affected (0.00 sec)
|
|
mysql> SELECT '\%b' LIKE '%\%';
|
+------------------+
|
| '\%b' LIKE '%\%' |
|
+------------------+
|
| 0 |
|
+------------------+
|
1 row in set (0.00 sec)
|
|
mysql> SET collation_connection = utf8mb4_unicode_520_ci;
|
Query OK, 0 rows affected (0.00 sec)
|
|
mysql> SELECT '\%b' LIKE '%\%';
|
+------------------+
|
| '\%b' LIKE '%\%' |
|
+------------------+
|
| 1 |
|
+------------------+
|
1 row in set (0.00 sec)
|