#9682: icontains can be case-sensitive on MySQL
-------------------------------------+-------------------------------------
Reporter: | Owner: nobody
to.roma.from.djbug@… |
Type: Bug | Status: new
Component: Database layer | Version: 1.0
(models, ORM) |
Severity: Normal | Resolution:
Keywords: | Triage Stage:
| Someday/Maybe
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by ringerc):
Readers should note that `COLLATE` is SQL-standard, though unfortunately
the collation ''names'' are not. You will be able to use a solution that
implements the `COLLATE` clause in PostgreSQL too, e.g.
`SELECT * FROM collate_demo WHERE test_col > 'A' COLLATE "C" ORDER BY
test_col COLLATE "C";`
to use POSIX byte-order based collation.
I ''strongly'' recommend a solution using the `COLLATE` clause, but keep
in mind that it's not a global query modifier. It affects the operator or
`ORDER BY` clause it's attached to, not the whole query.
''(I don't use Django, I contribute to PostgreSQL and I'm here because of
some research I was doing for a Stack Overflow user who runs Django on
Pg)''.
--
Ticket URL: <https://code.djangoproject.com/ticket/9682#comment:15>
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 post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-updates/088.5b161fe449af67c32e27a6a2f2186ee1%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.
