Opened 5 years ago
Last modified 5 years ago
#30248 closed New feature
Implement case insensitive fields in Sqlite — at Initial Version
| Reported by: | Stuart Axon | Owned by: | nobody |
|---|---|---|---|
| Component: | Database layer (models, ORM) | Version: | dev |
| Severity: | Normal | Keywords: | sqlite citext postgres |
| Cc: | Triage Stage: | Unreviewed | |
| Has patch: | no | Needs documentation: | no |
| Needs tests: | no | Patch needs improvement: | no |
| Easy pickings: | no | UI/UX: | no |
Description
Sqlite supports case insensitive fields by setting COLLATE NOCASE.
This works as you would expect for SELECT and INSERT.
It would be great to have equivalents to the CIText fields in postgres.contrib - this would make it a lot easier to unit test code using those fields.
Note:
See TracTickets
for help on using tickets.