Character set and utf8mb4

Last reviewed May 28, 2026 Content v20260528

Track mode

sql_sandbox

Means

SQL sandbox

Reading

~1 min

Level

beginner

This lesson

This lesson teaches Character set and utf8mb4: the SQL patterns, schema habits, and query reasoning you need before advancing in MySQL.

Emoji and international text fail silently with wrong charset—utf8mb4 end-to-end is non-negotiable in production.

You will apply Character set and utf8mb4 in contexts like: Web apps on shared hosting, ecommerce, and many startups’ first production DB.

Copy MySQL SQL into the mysql client, local MySQL/MariaDB, or DB Fiddle (MySQL dialect)—use DESCRIBE and EXPLAIN where lessons show them. The in-browser lab ships later; mysql client is the practice path now. Also verify charset utf8mb4 on database, table, and connection.

When you can explain the previous lesson's ideas without copying example queries verbatim.

Use utf8mb4 with a sensible collation (e.g. utf8mb4_unicode_ci) so emoji and all Unicode store correctly—legacy utf8 is incomplete.

Database and table defaults

CREATE DATABASE practice
  CHARACTER SET utf8mb4
  COLLATE utf8mb4_unicode_ci;

CREATE TABLE users (
  email VARCHAR(255) NOT NULL,
  display_name VARCHAR(255) NOT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Practice: Run on database practice in mysql client.

Collation affects sorting

_ci collations are case-insensitive for equality—pick explicitly for indexes and UNIQUE constraints.

Connection charset

Set client charset in PDO/Laravel so bytes on the wire match table definition—mojibake is a common production bug.

Important interview questions and answers

Q: utf8 vs utf8mb4?
A: utf8 in MySQL is 3-byte subset; utf8mb4 is full Unicode.
Q: Collation on email UNIQUE?
A: Case sensitivity depends on collation—test login lookups.

Self-check

Why utf8mb4 for new projects?
What does COLLATE control?

Tip: Emoji test: insert 🎉 and verify round-trip in app.

Interview prep

utf8 trap?: MySQL utf8 is 3-byte—utf8mb4 is full Unicode.
Collation?: Defines sort/compare rules including case sensitivity.

Discussion

Past discussion is visible to everyone. Only logged-in users can post comments and replies.

Starter discussion topics

Emoji test?
Collation on email?

No discussion yet. Be the first to ask a question.