Do we want Bugzilla to be case-sensitive or case-insensitive?
bbaetz at acm.org
Thu Nov 3 08:32:30 UTC 2005
On Thu, Nov 03, 2005 at 02:14:41AM +0100, Frédéric Buclin wrote:
> On IRC, some of us came to the conclusion that choosing either
> PostgreSQL or MySQL is a strategical choice, depending of what companies
> want in terms of intrinsic properties. In the same way some users like
> *nix case-sensitiveness, some others prefer windows case-insensitiveness.
This really isn't the way to make a decision.
In practice, it dosn't really matter. Pg will let you have products
called ABC and abc, and mysql won't. The user just chooses whatever they
want from a list. As long as we have approriate functional indexes so
that searching is fast, noone will care. (I think that tsearch2 is case
insensitve, anyway. Not 100% sure, though)
Things such as emails that are inherantly case insensitive should just
be case folded before putting it into the DB (You can enforce that with
a check constraint in pg if you really want)
There are many reasons to choose a database to use. Case folding should
be well down the list.. (unless, of course, you *need* to have something
case sensitive for the purposes of unique keys. thats fairly rare,
More information about the developers