MySQL 8.0

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

select version();

version()

8.0.36

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

character_sets_dir
/usr/share/mysql-8.0/charsets/

SELECT '🐬';

?

🐬

CREATE TABLE before_table (field text);
SHOW CREATE TABLE before_table;

Table
Create Table

before_table
CREATE TABLE `before_table` (
  `field` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

INSERT INTO before_table (field) VALUES ('🐬');
SELECT * FROM before_table;

field

🐬

SET CHARSET 'utf8'; -- This is currently what Django does
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
utf8mb3

character_set_server
utf8mb4

character_set_system
utf8mb3

character_sets_dir
/usr/share/mysql-8.0/charsets/

SELECT '🐬';

????

????

CREATE TABLE after_table (field text);
SHOW CREATE TABLE after_table;

Table
Create Table

after_table
CREATE TABLE `after_table` (
  `field` text
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

INSERT INTO after_table (field) VALUES ('🐬');
SELECT * FROM after_table;

field

????

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
character_sets_dir	/usr/share/mysql-8.0/charsets/