Ilja Booij <[EMAIL PROTECTED]> said: > > Ilja Booij wrote: > > Paul J Stevens wrote: > >> So if the sysadmin changes the table spec to include the BINARY > >> keyword folders become case-sensitive ? > >> > > > > I would think so, unless we've already made assumptions on the mailbox > > names being case insensitive.
I'm fairly certain that there are a number of places where the comparison is made explicitly case insensitive. IMHO, these were probably added to make the queries more similar to the username and alias lookups... except that usernames and aliases are typed in by humans who cannot remember case and aren't required to do so by RFC. The mailbox names are 99.44% captive user interface generated, and so case sensitivity won't confuse anyone (the last 0.56% are crazy people who always remember case sensitivity). > > I'll give it a spin. > > I've just tried it on PostgreSQL, which is case sensitive in varchar > fields. I can create mailboxes with names only different in case there. Anything that we can do to reduce the differences between DBMail-MySQL and DBMail-PostgreSQL is a Very Good Thing (TM)! > On MySQL, adding BINARY to the name field in the mailboxes table yields > the same result. Sounds reasonable. > Should we make this default? > > Ilja >
