#31016: Documentation: MySQL notes: utf8
-------------------------------------+-------------------------------------
Reporter: minusf | Owner: nobody
Type: | Status: new
Uncategorized |
Component: | Version: 2.2
Documentation | Keywords: mysql mariadb utf8
Severity: Normal | utf8mb4
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 1
UI/UX: 0 |
-------------------------------------+-------------------------------------
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.
--
Ticket URL: <https://code.djangoproject.com/ticket/31016>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/049.31aed75eb66ceddb9bd2d5acc380a10c%40djangoproject.com.
