Do we want Bugzilla to be case-sensitive or case-insensitive?

[Bradley Baetz]

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,
though...)

Bradley