From 63300f7e686c2c452763cb512df9abf7734fd588 Mon Sep 17 00:00:00 2001
From: Tom Carrick <tom@carrick.eu>
Date: Sat, 8 Aug 2020 13:37:06 +0200
Subject: Fixed #21181 -- Added Collate database function.

Thanks Simon Charette for reviews.
---
 docs/ref/models/database-functions.txt | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'docs/ref')

diff --git a/docs/ref/models/database-functions.txt b/docs/ref/models/database-functions.txt
index da67d9e362..f5efdb7e87 100644
--- a/docs/ref/models/database-functions.txt
+++ b/docs/ref/models/database-functions.txt
@@ -87,6 +87,25 @@ Usage examples::
     >>> now = timezone.now()
     >>> Coalesce('updated', Cast(now, DateTimeField()))
 
+``Collate``
+-----------
+
+.. class:: Collate(expression, collation)
+
+.. versionadded:: 3.2
+
+Takes an expression and a collation name to query against.
+
+For example, to filter case-insensitively in SQLite::
+
+    >>> Author.objects.filter(name=Collate(Value('john'), 'nocase'))
+    <QuerySet [<Author: John>, <Author: john>]>
+
+It can also be used when ordering, for example with PostgreSQL::
+
+    >>> Author.objects.order_by(Collate('name', 'et-x-icu'))
+    <QuerySet [<Author: Ursula>, <Author: Veronika>, <Author: Ülle>]>
+
 ``Greatest``
 ------------
 
-- 
cgit v1.3