Your database Code quality Stability Security & compliance

MySQL table not utf8mb4

Part of the Schema & indexes check · fix arrives as a guide

What it is

A MySQL table uses a character set other than utf8mb4.

Why it matters

MySQL's utf8 is a three-byte encoding that cannot store four-byte characters, so emoji and some scripts are truncated or rejected on insert. The failure is data-dependent, which is why it surfaces in production rather than in tests.

How to fix it

Convert the table and its columns to utf8mb4 with an appropriate collation. Check index key lengths before converting, since the wider encoding can exceed prefix limits on older versions.

Also in Schema & indexes

Table has no primary key Your databaseSchema & indexes Foreign key has no covering index Your databaseSchema & indexes Large table with only its base/PK index Your databaseSchema & indexes SQL Server heap (no clustered index) Your databaseSchema & indexes MongoDB collection with no indexes Your databaseSchema & indexes MySQL table uses MyISAM (no transactions) Your databaseSchema & indexes

Run them all on your app

Connect your repo and your live services with read-only scopes. The first scan is free, and nothing changes without your approval.

Guard my app · Free → View pricing