summaryrefslogtreecommitdiff
path: root/docs/ref/models
diff options
context:
space:
mode:
Diffstat (limited to 'docs/ref/models')
-rw-r--r--docs/ref/models/querysets.txt29
1 files changed, 27 insertions, 2 deletions
diff --git a/docs/ref/models/querysets.txt b/docs/ref/models/querysets.txt
index 3525865ac6..262eff1388 100644
--- a/docs/ref/models/querysets.txt
+++ b/docs/ref/models/querysets.txt
@@ -986,8 +986,15 @@ SQL equivalent::
SELECT ... WHERE name ILIKE 'beatles blog';
-Note this will match ``'Beatles Blog'``, ``'beatles blog'``,
-``'BeAtLes BLoG'``, etc.
+Note this will match ``'Beatles Blog'``, ``'beatles blog'``, ``'BeAtLes
+BLoG'``, etc.
+
+.. admonition:: SQLite users
+
+ When using the SQLite backend and Unicode (non-ASCII) strings, bear in
+ mind the :ref:`database note <sqlite-string-matching>` about string
+ comparisons. SQLite does not do case-insensitive matching for Unicode
+ strings.
contains
~~~~~~~~
@@ -1021,6 +1028,12 @@ SQL equivalent::
SELECT ... WHERE headline ILIKE '%Lennon%';
+.. admonition:: SQLite users
+
+ When using the SQLite backend and Unicode (non-ASCII) strings, bear in
+ mind the :ref:`database note <sqlite-string-matching>` about string
+ comparisons.
+
in
~~
@@ -1109,6 +1122,12 @@ SQL equivalent::
SELECT ... WHERE headline ILIKE 'Will%';
+.. admonition:: SQLite users
+
+ When using the SQLite backend and Unicode (non-ASCII) strings, bear in
+ mind the :ref:`database note <sqlite-string-matching>` about string
+ comparisons.
+
endswith
~~~~~~~~
@@ -1138,6 +1157,12 @@ SQL equivalent::
SELECT ... WHERE headline ILIKE '%will'
+.. admonition:: SQLite users
+
+ When using the SQLite backend and Unicode (non-ASCII) strings, bear in
+ mind the :ref:`database note <sqlite-string-matching>` about string
+ comparisons.
+
range
~~~~~