#33849: Like statement is not case-sensitive in SQLite backend
-------------------------------------+-------------------------------------
Reporter: Ali | Owner: nobody
Type: Bug | Status: closed
Component: Database layer | Version:
(models, ORM) |
Severity: Normal | Resolution: duplicate
Keywords: Sqlite __contains | Triage Stage:
__icontains | Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Mariusz Felisiak):
Replying to [comment:2 Ali]:
> We have **PRAGMA** statement called **case_sensitive_like**, which is
designed to specifically make the LIKE operator case-sensitive for ASCII
characters, see the
[https://www.sqlite.org/pragma.html#pragma_case_sensitive_like document],
so we can use it to fix this?
This is also discussed in the original ticket:
> ''" (With the case_sensitive_like=true, just the top left is changed,
which is not an improvement). Unfortunately, this means we've got problems
with Unicode whichever way we go, because we don't have a way of doing
case insensitive matching. "''
--
Ticket URL: <https://code.djangoproject.com/ticket/33849#comment:3>
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 on the web visit
https://groups.google.com/d/msgid/django-updates/0107018206cbffa7-eafee5c2-26fb-482b-bfcd-256eda61cbf9-000000%40eu-central-1.amazonses.com.
