Ilja Booij wrote:
well, after some more reading, I guess it's a bit different:
IMAP RFC3501 takes no position on case sensitivity in mailbox names. So,
we can support either case sensitive or case insensitive mailbox names.
Currently, mailboxes are case sensitive when using PostgreSQL, and case
insensitive when using MySQL. This might not be what we want. We would
probably like to have case sensitivity to be consistent, whichever
database backend we use.
any opinions?
Ilja
From http://www.mysql.com/doc/en/String_comparison_functions.html
The following two statements illustrate that string comparisons
are not case sensitive unless one of the operands is a binary string:
mysql> SELECT 'abc' LIKE 'ABC';
-> 1
mysql> SELECT 'abc' LIKE BINARY 'ABC';
-> 0
/Magnus
