summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMoayad Mardini <moayad.m@gmail.com>2014-04-18 18:41:29 +0200
committerTim Graham <timograham@gmail.com>2014-04-18 15:11:10 -0400
commitb1e7dd445bb64c27df8e2b6902a76a67c79332ab (patch)
tree7a0ec1322c24ee156cad43291187e5802aea1c93
parent1816baf4f7de0a1557108e1d26f754eca3e543c0 (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.txt9
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
--------------------------