id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
31016	Documentation: MySQL notes: utf8.	minusf	nobody	"https://docs.djangoproject.com/en/2.2/ref/databases/#creating-your-database

Currently the documentation recommends using the following SQL to create a 'utf8' database:

{{{
CREATE DATABASE <dbname> CHARACTER SET utf8;
}}}


Claiming ""This ensures all tables and columns will use UTF-8 by default.""

Currently in mysql (and mariadb) `utf8` means only a subset of `UTF-8`. To get the full range one must use `utf8mb4` (which will be the default somewhere in mysql 8).

I think the advice should be amended to use `utf8mb4` as it is misleading at the moment. Or at the very least the followup sentence should mention that `utf8` creates only a subset of characters, and not all utf8 can be stored in it."	Cleanup/optimization	closed	Documentation	dev	Normal	duplicate	mysql mariadb utf8 utf8mb4		Unreviewed	0	0	0	0	0	0