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
21359	Wrong collation names in the section about MySQL collations	Kal Sze	nobody	"This page mentions inexistent collation names: [https://docs.djangoproject.com/en/1.4/ref/databases/#collation-settings]

`utf8_general_ci_swedish` and `utf8_collation_ci_swedish` are not real collations names.

I believe the author was confusing the default collations for `latin1` and `utf8` charsets.

The default collation for the `latin1` charset is `latin1_swedish_ci`.
The default collation for the `utf8` charset is `utf8_unicode_ci`.

The mistakes persist in the latest dev documentation ([https://docs.djangoproject.com/en/dev/ref/databases/#collation-settings])

While we're at it, may I suggest to abandon `utf8` in favour of `utf8mb4`? The details deserve a separate ticket for discussion, so I'll create a new ticket and link here."	Uncategorized	closed	Documentation	dev	Normal	fixed	mysql, collations, documentation	bmispelon@…	Accepted	0	0	0	0	1	0