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

[byron]

> > insensitive.
> 
> 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.

yeah, but database choice shouldn't affect how bugzilla works.

> Forcing all comparisons to be case-insensitive would require to rewrite 
> 98% of all SQL queries!!

eww.

> case-insensitive. But it appears that is *not* possible to change this 
> behavior in PostgreSQL, at all. I don't know how Oracle behaves, though.

for what it's worth, ms-sql is case-insensitive by default.

the default behavour is chosen as install time, and with ms-sql 2000 it's set
at database/table creation time.  so you can't change it without recreating
the database and/or table.

to do case sensitivity against a table that has case-insensitive collation you
need to cast the fields _and_ data as varbinary

  select * from users where cast(username as varbinary) = cast('byron.jones'
    as varbinary)

of course this is ms-sql specific.

> No matter what we choose, it won't be a simple problem to fix. :(

roger that!



-b

begin-base64 644 signature.gif
R0lGODlhbQAHAIAAAABPo////ywAAAAAbQAHAAACfAxuGAnch+Bibkn7FL1p
XgVl4Ig1jjlZRoqybgun2Cur5uOunq7u/Ipq7WIyIc7XG9JquEgumPzdlhTf
h0O83kDJaXEm8mRHwXKJy5sac7qYOpT+gtv0n+0ujQOfdqh16caWt0foBViH
N1PRMXimiLUGt3ElVimlgbllWAAAOw==
====