#33849: Like statement is not case-sensitive in SQLite backend
-------------------------------------+-------------------------------------
Reporter: Ali | Owner: nobody
Type: Bug | Status: new
Component: Database | Version:
layer (models, ORM) | Keywords: Sqlite __contains
Severity: Normal | __icontains
Triage Stage: | Has patch: 0
Unreviewed |
Needs documentation: 0 | Needs tests: 0
Patch needs improvement: 0 | Easy pickings: 0
UI/UX: 0 |
-------------------------------------+-------------------------------------
**Like** statement is not **case-sensitive** in SQLite backend.
I know that was mentioned in the documentation, but I think the **Glob**
statement may solve it or the alternative statements for ''Like'',
the ''contains'' and ''icontains'' lookup has the same behavior because
using the Like statement in the query, like this :
{{{
"SELECT ### FROM #### WHERE ### LIKE %####%"
}}}
but we can change it to this :
{{{
"SELECT ### FROM #### WHERE ### GLOB *####*"
}}}
for **contains** lookup in the SQLite backend, because the Glob statement
is case-sensitive,the **Regex** statement also its a candidate
--
Ticket URL: <https://code.djangoproject.com/ticket/33849>
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/010701820651200b-ab9a3973-85f5-4fe1-af2b-4e691e25b648-000000%40eu-central-1.amazonses.com.
