diff options
Diffstat (limited to 'docs/ref/models')
| -rw-r--r-- | docs/ref/models/querysets.txt | 29 |
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 ~~~~~ |
