#36261: `icontains` lookup doesn't work with case insensitive collations
-------------------------------------+-------------------------------------
Reporter: Craig de Stigter | Owner: (none)
Type: New feature | Status: closed
Component: Database layer | Version:
(models, ORM) |
Severity: Normal | Resolution: wontfix
Keywords: collation | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Natalia Bidart):
* keywords: => collation
* resolution: => wontfix
* status: new => closed
* type: Bug => New feature
Comment:
Thank you, Craig, for the ticket report, and Simon for the additional
context on PostgreSQL 18's improvements.
This issue has been previously discussed
[https://forum.djangoproject.com/t/icontains-lookup-when-using-
nondeterministic-collations-in-postgres-fails/25696/5 in this forum post],
covering both `LIKE` lookups and index creation challenges. Additionally,
[https://adamj.eu/tech/2023/02/23/migrate-django-postgresql-ci-fields-
case-insensitive-collation/ Adam Johnson's post] provides a step-by-step
guide to addressing these issues.
Given that PostgreSQL 18 is expected in September 2025 and Django 6.0's
feature freeze is set for September 17, 2025, support for PostgreSQL 18
will likely land in Django 6.1. Therefore, I'm inclined to closing this as
`wontfix` for now. Any new findings can be shared in the referenced forum
post, and if a clear implementation path emerges, I'd be happy to reopen
this ticket.
--
Ticket URL: <https://code.djangoproject.com/ticket/36261#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
--
You received this message because you are subscribed to the Google Groups
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/django-updates/01070195a456e02e-f39d1f65-368b-4c19-a595-beff0348c2b8-000000%40eu-central-1.amazonses.com.
