From ff3320cb6dffba80058c0b88318c2f314f024497 Mon Sep 17 00:00:00 2001 From: Malcolm Tredinnick Date: Tue, 6 Jan 2009 03:35:46 +0000 Subject: [1.0.X] Documented that case-insensitive matching is not supported for non-ASCII strings in SQLite. Refs #9905. Backport of r9705 from trunk. git-svn-id: http://code.djangoproject.com/svn/django/branches/releases/1.0.X@9706 bcc190cf-cafb-0310-a4f2-bffc1f526a37 --- docs/ref/models/querysets.txt | 29 +++++++++++++++++++++++++++-- 1 file changed, 27 insertions(+), 2 deletions(-) (limited to 'docs/ref/models') 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 ` 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 ` 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 ` 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 ` about string + comparisons. + range ~~~~~ -- cgit v1.3