Re: [Django] #5745: MySQL Collations/Charsets and Engines
Django
-------------------------------------+-------------------------------------
Reporter: Armin | Owner: nobody
Ronacher | Status: new
Type: New | Component: Database layer
feature | (models, ORM)
Milestone: | Severity: Normal
Version: SVN | Keywords:
Resolution: | Has patch: 0
Triage Stage: Accepted | Needs tests: 0
Needs documentation: 0 | Easy pickings: 0
Patch needs improvement: 0 |
UI/UX: 0 |
-------------------------------------+-------------------------------------
Changes (by jdchrist@…):
* cc: jdchrist@… (added)
* ui_ux: => 0
* easy: => 0
--
Ticket URL: <https://code.djangoproject.com/ticket/5745#comment:13>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.
Django
-------------------------------------+-------------------------------------
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mysql | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by collinanderson):
* keywords: => mysql
* cc: cmawebsite@… (added)
--
Ticket URL: <https://code.djangoproject.com/ticket/5745#comment:14>
Django
-------------------------------------+-------------------------------------
Reporter: Armin Ronacher | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mysql | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* cc: shaib (added)
Comment:
For the record:
All core backends (except Oracle, it seems) can set collation per column;
collation names are not standard (and SQLite has only 3 built-in
collations, none of them reasonable for any native language). Except (I
think) for Oracle, they can also set collation for a specific query (the
collation can be used in ordering comparisons or in `ORDER BY`). This
means that any reasonable collation support in core would beget backend-
specific usages, which I wouldn't like.
However, I think core should make it possible to add collation support via
external libraries. I would like to see the API for such extension.
Of all core backends, the only one which can set the character encoding at
a level lower than the whole database is MySQL. Since Django does not
usually create databases (except for test databases), I think this feature
should not be added (except, with the API mentioned above, in a MySQL-
specific library outside core).
--
Ticket URL: <https://code.djangoproject.com/ticket/5745#comment:15>
Django
-------------------------------------+-------------------------------------
Reporter: Armin Ronacher | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mysql | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* cc: me@… (added)
--
Ticket URL: <https://code.djangoproject.com/ticket/5745#comment:16>
Django
-------------------------------------+-------------------------------------
Reporter: Armin Ronacher | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mysql | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* cc: Adam (Chainz) Johnson (added)
--
Ticket URL: <https://code.djangoproject.com/ticket/5745#comment:17>
Django
-------------------------------------+-------------------------------------
Reporter: Armin Ronacher | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: master
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mysql | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* cc: Peter Thomassen (added)
--
Ticket URL: <https://code.djangoproject.com/ticket/5745#comment:18>
Django
-------------------------------------+-------------------------------------
Reporter: Armin Ronacher | Owner: nobody
Type: New feature | Status: new
Severity: Normal | Resolution:
Keywords: mysql | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
* cc: Clifford Gama (added)
--
Ticket URL: <https://code.djangoproject.com/ticket/5745#comment:19>
Django
-------------------------------------+-------------------------------------
Reporter: Armin Ronacher | Owner: nobody
Type: New feature | Status: new
Component: Database layer | Version: dev
(models, ORM) |
Severity: Normal | Resolution:
Keywords: mysql | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Related to #18392
--
Ticket URL: <https://code.djangoproject.com/ticket/5745#comment:20>