diff options
| author | Moayad Mardini <moayad.m@gmail.com> | 2014-04-18 18:41:29 +0200 |
|---|---|---|
| committer | Tim Graham <timograham@gmail.com> | 2014-04-18 15:11:10 -0400 |
| commit | b1e7dd445bb64c27df8e2b6902a76a67c79332ab (patch) | |
| tree | 7a0ec1322c24ee156cad43291187e5802aea1c93 | |
| parent | 1816baf4f7de0a1557108e1d26f754eca3e543c0 (diff) | |
[1.7.x] Fixed #22458 -- Added a note about MySQL utf8_unicode_ci collation
Thanks tobami at gmail.com for the report.
Backport of 11ac50b18e from master
| -rw-r--r-- | docs/ref/databases.txt | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt index f2ed1c6b7a..fa4fe638e9 100644 --- a/docs/ref/databases.txt +++ b/docs/ref/databases.txt @@ -388,6 +388,15 @@ table (usually called ``django_session``) and the .. _fixed in MySQLdb 1.2.2: http://sourceforge.net/tracker/index.php?func=detail&aid=1495765&group_id=22307&atid=374932 +Please note that according to `MySQL Unicode Character Sets`_, comparisons for +the ``utf8_general_ci`` collation are faster, but slightly less correct, than +comparisons for ``utf8_unicode_ci``. If this is acceptable for your application, +you should use ``utf8_general_ci`` because it is faster. If this is not acceptable +(for example, if you require German dictionary order), use ``utf8_unicode_ci`` +because it is more accurate. + +.. _MySQL Unicode Character Sets: http://dev.mysql.com/doc/refman/5.7/en/charset-unicode-sets.html + Connecting to the database -------------------------- |
