Custom collations

[Tom Carrick]

Mailing list, but it didn't get any responses: ​https://groups.google.com/u/2/g/django-developers/c/djMQwwxtCVY

We have the various CI fields on postgres, but these are ​discouraged since pg12 in favour of ​nondeterministic collations. I think it'd be useful to have a way to do this in Django, though I'm not sure what the API would look like. My initial thought, knowing very little about the ORM, is a Collation class that can be passed into a model field, but I'm not sure.

​PR

[Simon Charette]

Related to #21181, #9682, and #5745.

[Carlton Gibson]

Mailing list, but it didn't get any responses...

Hi Tom. I feel bad saying you need to go back to the mailing list, but without SOME proposal this isn't really actionable as it stands.

You've got Simon's attention now, so there's hope there... 🙂

Short of that, I'd suggest sketching up some ideas and following up your initial post. (Having just looked at it, it's a bit "Argh! no idea", at first glance.)

I'm going to close as needs info for now. Really happy to re-open either we have some suggestions for the API, or (less good) we're happy to leave it open even undefined, but then I'd probably want to mark it Someday/Maybe. I hope that makes sense.

[Aymeric Augustin]

Hello Carlton, given that there's a PR that looks quite reasonable and a bit of support on the mailing list, I'm going to reopen and accept.

The ticket was short on details; the PR makes things clearer.

Essentially this is adding ORM support for a feature that most databases support. I'm not seeing obvious drawbacks. Hence, accepting.

[Carlton Gibson]

Super. Thanks!

[Mariusz Felisiak]

You shouldn't mark you own PRs as ready for checkin.

[Mariusz Felisiak <felisiak.mariusz@…>]

In e387f191:

Fixed #31777 -- Added support for database collations to Char/TextFields.

Thanks Simon Charette and Mariusz Felisiak for reviews.

[GitHub <noreply@…>]

In 292b3be6:

Refs #31777 -- Doc'd Char/TextField.db_collation parameter in MySQL notes.