[Django] #21359: Wrong collation names in the section about MySQL collations

Django

unread,

Oct 31, 2013, 4:45:39 AM10/31/13

to django-...@googlegroups.com

#21359: Wrong collation names in the section about MySQL collations
----------------------------+----------------------------------------------
Reporter: k_sze | Owner: nobody
Type: | Status: new
Uncategorized | Version: 1.4
Component: | Keywords: mysql, collations, documentation
Documentation | Has patch: 0
Severity: Normal | UI/UX: 0
Triage Stage: Unreviewed |
Easy pickings: 1 |
----------------------------+----------------------------------------------
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.

--
Ticket URL: <https://code.djangoproject.com/ticket/21359>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,

Oct 31, 2013, 4:49:45 AM10/31/13

to django-...@googlegroups.com

#21359: Wrong collation names in the section about MySQL collations

-------------------------------------+-------------------------------------
Reporter: k_sze | Owner: nobody
Type: Uncategorized | Status: new
Component: Documentation | Version: 1.4
Severity: Normal | Resolution:
Keywords: mysql, collations, | Triage Stage:
documentation | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 1 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by k_sze):

* needs_better_patch: => 0
* needs_tests: => 0
* needs_docs: => 0

Comment:

Actually `utf8mb4` is already mentioned here:
https://code.djangoproject.com/ticket/18392

--
Ticket URL: <https://code.djangoproject.com/ticket/21359#comment:1>

Django

unread,

Oct 31, 2013, 5:52:53 AM10/31/13

to django-...@googlegroups.com

#21359: Wrong collation names in the section about MySQL collations

-------------------------------------+-------------------------------------
Reporter: k_sze | Owner: nobody
Type: Uncategorized | Status: new
Component: Documentation | Version: master
Severity: Normal | Resolution:
Keywords: mysql, collations, | Triage Stage: Accepted
documentation | Needs documentation: 0
Has patch: 0 | Patch needs improvement: 0
Needs tests: 0 | UI/UX: 0
Easy pickings: 1 |
-------------------------------------+-------------------------------------
Changes (by bmispelon):

* cc: bmispelon@… (added)
* version: 1.4 => master
* stage: Unreviewed => Accepted

Comment:

Hi,

The best reference I could find on the subject was this page:
http://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html

It's supposed to list all the available `utf8_*` collations and it appears
that `utf8_general_ci_swedish` and `utf8_collation_ci_swedish` are indeed
not on it.

However, it also says that the default collation for the `utf8` charset is
`utf8_general_ci`, not `utf8_unicode_ci`.

(Note that I don't have access to a mysql database to test this out and
I'm only relying on the docunmentation I could find)

Thanks.

--
Ticket URL: <https://code.djangoproject.com/ticket/21359#comment:2>

Django

unread,

Oct 31, 2013, 6:32:17 AM10/31/13

to django-...@googlegroups.com

#21359: Wrong collation names in the section about MySQL collations

-------------------------------------+-------------------------------------
Reporter: k_sze | Owner: nobody

Comment (by claudep):

I can confirm that on my system (MySQL 5.5), default collation for utf8 is
`utf8_general_ci`:
{{{
mysql> SHOW COLLATION LIKE 'utf8\_%';
+--------------------------+---------+-----+---------+----------+---------+
| Collation | Charset | Id | Default | Compiled | Sortlen
|
+--------------------------+---------+-----+---------+----------+---------+
| utf8_general_ci | utf8 | 33 | Yes | Yes | 1
|
...
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/21359#comment:3>

Django

unread,

Oct 31, 2013, 9:50:43 PM10/31/13

to django-...@googlegroups.com

#21359: Wrong collation names in the section about MySQL collations

-------------------------------------+-------------------------------------
Reporter: k_sze | Owner: nobody

Comment (by k_sze):

Right, I meant to write `utf8_general_ci` for `utf8`.

--
Ticket URL: <https://code.djangoproject.com/ticket/21359#comment:4>

Django

unread,

Nov 1, 2013, 5:46:17 AM11/1/13

to django-...@googlegroups.com

#21359: Wrong collation names in the section about MySQL collations

-------------------------------------+-------------------------------------
Reporter: k_sze | Owner: nobody
Type: Uncategorized | Status: closed
Component: Documentation | Version: master
Severity: Normal | Resolution: fixed

Changes (by Claude Paroz <claude@…>):

* status: new => closed
* resolution: => fixed

Comment:

In [changeset:"67c6c1a7cb2ef971497ba8827be5d6e781c0d2e8"]:
{{{
#!CommitTicketReference repository=""
revision="67c6c1a7cb2ef971497ba8827be5d6e781c0d2e8"
Fixed #21359 -- Corrected MySQL collation name in databases docs

Thanks k_sze for the report.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/21359#comment:5>

Django

unread,

Nov 1, 2013, 5:47:16 AM11/1/13

to django-...@googlegroups.com

#21359: Wrong collation names in the section about MySQL collations

-------------------------------------+-------------------------------------
Reporter: k_sze | Owner: nobody

Comment (by Claude Paroz <claude@…>):

In [changeset:"f03c699159af53725b08aa5d8f7efb74b4662816"]:
{{{
#!CommitTicketReference repository=""
revision="f03c699159af53725b08aa5d8f7efb74b4662816"
[1.6.x] Fixed #21359 -- Corrected MySQL collation name in databases docs

Thanks k_sze for the report.

Backport of 67c6c1a7c from master.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/21359#comment:6>

Django

unread,

Nov 1, 2013, 5:48:06 AM11/1/13

to django-...@googlegroups.com

#21359: Wrong collation names in the section about MySQL collations

-------------------------------------+-------------------------------------
Reporter: k_sze | Owner: nobody

Comment (by Claude Paroz <claude@…>):

In [changeset:"dd0c204828f58f63caa573b0a03df7665c97e6d3"]:
{{{
#!CommitTicketReference repository=""
revision="dd0c204828f58f63caa573b0a03df7665c97e6d3"
[1.5.x] Fixed #21359 -- Corrected MySQL collation name in databases docs