MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.36

CREATE TABLE table_mb3 (field text) ENGINE=InnoDB DEFAULT CHARSET=utf8
SET CHARSET 'utf8';
INSERT INTO table_mb3 (field) VALUES ('foo🐬bar');
SELECT * FROM table_mb3;

field

foo????bar

SELECT * FROM table_mb3 WHERE field = 'foo🐬bar';

field

foo????bar

SET CHARSET 'utf8mb4';
SELECT * FROM table_mb3;

field

foo????bar

INSERT INTO table_mb3 (field) VALUES ('foo🐬bar');

Incorrect string value: '\xF0\x9F\x90\xACba...' for column 'field' at row 1

SELECT * FROM table_mb3 WHERE field = 'foo🐬bar';

Illegal mix of collations (utf8mb3_general_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation '='

SELECT * FROM table_mb3 WHERE field LIKE 'foo%';

field

foo????bar