Changeset 8319

Timestamp:

08/12/08 02:52:33 (4 months ago)

Author:

mtredinnick

Message:

Changed "exact" matches in MySQL to use the database's native collation.

This effectively reverses the change in [7798]. It was proving too difficult to
successfully manage all the side effects here and provide a satisfactory
solution for everybody. Many thanks to arne, Martin von Löwis and, particular,
Karen Tracey, for doing a lot of research and proto-patches here to establish what was possible and practical.

This is backwards incompatible if you were relying on the behaviour after
[7798]. The docs have been updated to indicate the solution.

Refs #2170, #7789, #8102.

Files:

• django/trunk/django/db/backends/mysql/base.py (modified) (1 diff)
• django/trunk/docs/db-api.txt (modified) (1 diff)
• django/trunk/tests/regressiontests/string_lookup/models.py (modified) (1 diff)

django/trunk/django/db/backends/mysql/base.py

@@ -154 +154 @@
-
-class DatabaseWrapper(BaseDatabaseWrapper):
-
+
-    operators = {
-BINARY 
+
-        'iexact': 'LIKE %s',
-        'contains': 'LIKE BINARY %s',

django/trunk/docs/db-api.txt

@@ -1328 +1328 @@
-anything. It has now been changed to behave the same as ``id__isnull=True``.
-
+.. admonition:: MySQL comparisons
+
+    In MySQL, whether or not ``exact`` comparisons are case-sensitive depends
+    upon the collation setting of the table involved. The default is usually
+    ``latin1_swedish_ci`` or ``utf8_swedish_ci``, which results in
+    case-insensitive comparisons. Change the collation to
+    ``latin1_swedish_cs`` or ``utf8_bin`` for case sensitive comparisons.
+
+    For more details, refer to the MySQL manual section about `character sets
+    and collations`_.
+
+.. _character sets and collations: http://dev.mysql.com/doc/refman/5.0/en/charset.html
+
-iexact
-~~~~~~

django/trunk/tests/regressiontests/string_lookup/models.py

@@ -98 +98 @@
-<Article: Article Test>
-
-# Regression tests for #2170: test case sensitiveness
->>> Article.objects.filter(text__exact='tHe qUick bRown fOx jUmps over tHe lazy dog.')
-[]
->>> Article.objects.filter(text__iexact='tHe qUick bRown fOx jUmps over tHe lazy dog.')
-[<Article: Article Test>]
-
->>> Article.objects.get(text__contains='quick brown fox')
-<Article: Article Test>