Opened 6 years ago

Closed 6 years ago

Last modified 15 months ago

#14310 closed Uncategorized (duplicate)

MySQL - collate in queries

Reported by: Jakub Roztočil Owned by: nobody
Component: Uncategorized Version: 1.2
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

From MySQL documentation:

With the COLLATE clause, you can override whatever the default collation is for a comparison. COLLATE may be used in various parts of SQL statements.

http://dev.mysql.com/doc/refman/5.0/en/charset-collate.html

It would be very useful to have access to this feature from the ORM (for example when you want to order the results by different than the default collate of the database).

Change History (2)

comment:1 Changed 6 years ago by Karen Tracey

Resolution: duplicate
Status: newclosed

This is essentially #9682

comment:2 Changed 15 months ago by Craig Ringer

Easy pickings: unset
Severity: Normal
Type: Uncategorized
UI/UX: unset

My comment https://code.djangoproject.com/ticket/9682#comment:15 on #9682 addresses this topic more specifically.

Note: See TracTickets for help on using tickets.
Back to Top