That cast method is not valid in postgresql however -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Magnus Sundberg Sent: Thursday, March 04, 2004 12:17 AM To: [email protected] Subject: Re: [Dbmail] CAP domain results in "no such user" mail bounce
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 _______________________________________________ Dbmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
