From 3b489b77429aacd05a66c2158edc4f21209aecb9 Mon Sep 17 00:00:00 2001 From: Malcolm Tredinnick Date: Tue, 6 Jan 2009 03:34:47 +0000 Subject: Documented that case-insensitive matching is not supported for non-ASCII strings in SQLite. Refs #9905. git-svn-id: http://code.djangoproject.com/svn/django/trunk@9705 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 2334cf0754..be78f85969 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 ~~ @@ -1133,6 +1146,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 ~~~~~~~~ @@ -1162,6 +1181,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