#36571: Deprecated usage of BINARY expr in MySQL lookups
-------------------------------------+-------------------------------------
Reporter: Simon Charette | Owner: (none)
Type: | Status: new
Cleanup/optimization |
Component: Database layer | Version: 5.2
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mysql binary like | Triage Stage:
| Unreviewed
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Comment (by Jason Hall):
Would `CAST(... AS BINARY)` be enough here? This only casts the pattern
and no the column? That might lead to subtle differences depending on the
column's collation or affect index usage. `COLLATE ..._bin` be closer to
the old `LIKE BINARY`, since it applies a binary collation to the column
and the pattern?
--
Ticket URL: <https://code.djangoproject.com/ticket/36571#comment:1>
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 django-updates+unsubscr...@googlegroups.com.
To view this discussion visit
https://groups.google.com/d/msgid/django-updates/01070198e32ba6df-90613186-477e-42b3-94ed-a711c7059d64-000000%40eu-central-1.amazonses.com.
