From 7136eb8f3a052afef29e343679e84e93d7e9e0a3 Mon Sep 17 00:00:00 2001 From: Adrian Holovaty Date: Tue, 1 Nov 2005 01:08:13 +0000 Subject: Fixed #507 -- Changed MySQL backend so that it uses 'LIKE BINARY' for case-sensitive comparisons -- contains, startswith and endswith. Thanks, Simon git-svn-id: http://code.djangoproject.com/svn/django/trunk@1036 bcc190cf-cafb-0310-a4f2-bffc1f526a37 --- docs/db-api.txt | 15 +++++++-------- 1 file changed, 7 insertions(+), 8 deletions(-) (limited to 'docs/db-api.txt') diff --git a/docs/db-api.txt b/docs/db-api.txt index b80d4e8647..1a4f488d50 100644 --- a/docs/db-api.txt +++ b/docs/db-api.txt @@ -161,9 +161,9 @@ The DB API supports the following lookup types: ``foo``, ``FOO``, ``fOo``, etc. contains Case-sensitive containment test: ``polls.get_list(question__contains="spam")`` returns all polls - that contain "spam" in the question. (PostgreSQL only. MySQL - doesn't support case-sensitive LIKE statements; ``contains`` - will act like ``icontains`` for MySQL.) + that contain "spam" in the question. (PostgreSQL and MySQL + only. SQLite doesn't support case-sensitive LIKE statements; + ``contains`` will act like ``icontains`` for SQLite.) icontains Case-insensitive containment test. gt Greater than: ``polls.get_list(id__gt=4)``. gte Greater than or equal to. @@ -174,11 +174,10 @@ The DB API supports the following lookup types: a list of polls whose IDs are either 1, 3 or 4. startswith Case-sensitive starts-with: ``polls.get_list(question_startswith="Would")``. (PostgreSQL - only. MySQL doesn't support case-sensitive LIKE statements; - ``startswith`` will act like ``istartswith`` for MySQL.) - endswith Case-sensitive ends-with. (PostgreSQL only. MySQL doesn't - support case-sensitive LIKE statements; ``endswith`` will act - like ``iendswith`` for MySQL.) + and MySQL only. SQLite doesn't support case-sensitive LIKE + statements; ``startswith`` will act like ``istartswith`` for + SQLite.) + endswith Case-sensitive ends-with. (PostgreSQL and MySQL only.) istartswith Case-insensitive starts-with. iendswith Case-insensitive ends-with. range Range test: -- cgit v1.3 From b5df9c308f169cdeaa9bf4490ed925cf95d0243a Mon Sep 17 00:00:00 2001 From: Adrian Holovaty Date: Wed, 2 Nov 2005 20:31:12 +0000 Subject: Improved docs/db-api.txt to specify that case-sensitive ordering isn't supported git-svn-id: http://code.djangoproject.com/svn/django/trunk@1051 bcc190cf-cafb-0310-a4f2-bffc1f526a37 --- docs/db-api.txt | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'docs/db-api.txt') diff --git a/docs/db-api.txt b/docs/db-api.txt index 1a4f488d50..01aacf49b1 100644 --- a/docs/db-api.txt +++ b/docs/db-api.txt @@ -239,6 +239,10 @@ so:: polls.get_list(order_by=['?']) +There's no way to specify whether ordering should be case sensitive. With +respect to case-sensitivity, Django will order results however your database +backend normally orders them. + Relationships (joins) ===================== -- cgit v1.3