--------------
SELECT @@version
--------------

+-----------+
| @@version |
+-----------+
| 8.0.25    |
+-----------+
1 row in set (0.00 sec)

--------------
SHOW VARIABLES LIKE 'character_set\_%'
--------------

+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| character_set_client     | utf8mb4 |
| character_set_connection | utf8mb4 |
| character_set_database   | utf8mb4 |
| character_set_filesystem | binary  |
| character_set_results    | utf8mb4 |
| character_set_server     | utf8mb4 |
| character_set_system     | utf8mb3 |
+--------------------------+---------+
7 rows in set (0.00 sec)

--------------
DROP TABLE IF EXISTS `btest`
--------------

Query OK, 0 rows affected (0.02 sec)

--------------
CREATE TABLE `btest` (
  `id` int unsigned NOT NULL PRIMARY KEY,
  `vcol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
--------------

Query OK, 0 rows affected (0.04 sec)

--------------
INSERT INTO btest (id, vcol) VALUES ('4231', 'Go2Zahadum') ON DUPLICATE KEY UPDATE id=id
--------------

Query OK, 1 row affected (0.01 sec)

--------------
INSERT INTO btest (id, vcol) VALUES (987, 'Go2Zahadum💕🌸now')
--------------

Query OK, 1 row affected (0.01 sec)

--------------
SELECT * FROM btest
--------------

+------+-----------------------+
| id   | vcol                  |
+------+-----------------------+
|  987 | Go2Zahadum💕🌸now         |
| 4231 | Go2Zahadum            |
+------+-----------------------+
2 rows in set (0.00 sec)

--------------
SELECT * FROM btest WHERE vcol LIKE 'Go2Zahadum💕🌸%'
--------------

+-----+-----------------------+
| id  | vcol                  |
+-----+-----------------------+
| 987 | Go2Zahadum💕🌸now         |
+-----+-----------------------+
1 row in set (0.00 sec)

--------------
SHOW WARNINGS
--------------

Empty set (0.00 sec)

--------------
SET SESSION character_set_client='utf8mb3'
--------------

Query OK, 0 rows affected, 1 warning (0.00 sec)

--------------
SHOW WARNINGS
--------------

+---------+------+---------------------------------------------------------------------------------------------+
| Level   | Code | Message                                                                                     |
+---------+------+---------------------------------------------------------------------------------------------+
| Warning | 1287 | 'utf8mb3' is deprecated and will be removed in a future release. Please use utf8mb4 instead |
+---------+------+---------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

--------------
SHOW VARIABLES LIKE 'character_set\_%'
--------------

+--------------------------+---------+
| Variable_name            | Value   |
+--------------------------+---------+
| character_set_client     | utf8mb3 |
| character_set_connection | utf8mb4 |
| character_set_database   | utf8mb4 |
| character_set_filesystem | binary  |
| character_set_results    | utf8mb4 |
| character_set_server     | utf8mb4 |
| character_set_system     | utf8mb3 |
+--------------------------+---------+
7 rows in set (0.00 sec)

--------------
SELECT * FROM btest WHERE vcol LIKE 'Go2Zahadum💕🌸%'
--------------

Empty set, 1 warning (0.00 sec)

--------------
SHOW WARNINGS
--------------

+---------+------+--------------------------------------------------------+
| Level   | Code | Message                                                |
+---------+------+--------------------------------------------------------+
| Warning | 1300 | Cannot convert string 'Go2Zah...' from utf8 to utf8mb4 |
+---------+------+--------------------------------------------------------+
1 row in set (0.01 sec)

--------------
SELECT * FROM btest
--------------

+------+-----------------------+
| id   | vcol                  |
+------+-----------------------+
|  987 | Go2Zahadum💕🌸now         |
| 4231 | Go2Zahadum            |
+------+-----------------------+
2 rows in set (0.00 sec)

--------------
SET NAMES utf8
--------------

Query OK, 0 rows affected, 1 warning (0.00 sec)

--------------
SELECT * FROM btest WHERE vcol LIKE 'Go2Zahadum💕🌸%'
--------------

ERROR 1267 (HY000) at line 20 in file: 'btest.sql': Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
Bye