Open
Bug 300417
Opened 20 years ago
[PostgreSQL] Case-insensitive Uniqueness can be cheaply enforced with a UNIQUE index
Categories
(Bugzilla :: Database, defect)
Tracking
()
NEW
People
(Reporter: mkanat, Unassigned)
References
Details
Right now, MySQL is entirely case-insensitive when you use the "=" operator or
similar operators.
Actually, PostgreSQL just uses the current character set, but I'm not aware of a
charset that has a case-insensitive collation that we could use.
Basically, this means that anywhere that we need things to be unique in a
case-insensitive fashion, PostgreSQL won't pick up.
However, we can cheaply enforce this with indexes on columns like:
LOWER(name), component_id
You need to log in
before you can comment on or make changes to this bug.
Description
•