SELECT @@version;
SHOW VARIABLES LIKE 'character_set\_%';
DROP TABLE IF EXISTS `btest`;
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;
INSERT INTO btest (id, vcol) VALUES ('4231', 'Go2Zahadum') ON DUPLICATE KEY UPDATE id=id;
INSERT INTO btest (id, vcol) VALUES (987, 'Go2Zahadum💕🌸now');
SELECT * FROM btest;
SELECT * FROM btest WHERE vcol LIKE 'Go2Zahadum💕🌸%';
SHOW WARNINGS;
SET SESSION character_set_client='utf8mb3';
SHOW WARNINGS;
SHOW VARIABLES LIKE 'character_set\_%';
SELECT * FROM btest WHERE vcol LIKE 'Go2Zahadum💕🌸%';
SHOW WARNINGS;
SELECT * FROM btest;
SET NAMES utf8;
SELECT * FROM btest WHERE vcol LIKE 'Go2Zahadum💕🌸%';