Case-insensitive searches with Lion

[Beatrix Willius]

Hi Valentina gang,

I'm giving my app a thorough outing on Lion/Cocoa and even simple things don't seems to work anymore. For case-insentive searches I have used for quite a while

  ValentinaDB.CollationAttribute(EVColAttribute.kStrength) = EVColAttributeValue.kSecondary
  ValentinaDB.CollationAttribute(EVColAttribute.kCaseFirst) = EVColAttributeValue.kLowerFirst

where the SQL is

SELECT Message.MailboxID, Message.RecID, Message.OriginatorFrom as [From], Message.ReceiverTo as [To], Message.MainSubject as [Subject], Message.MainDateTime as [Date], Message.AttachmentCount as [Att.], MailboxName(Mailbox.Mailboxpath) as [Mailbox]  FROM Message INNER JOIN Mailbox ON Message.MailboxID = Mailbox.RecID WHERE Message.MailboxID = :1 GROUP BY Message.MailboxID, Message.RecID, Message.OriginatorFrom, Message.ReceiverTo, Message.MainSubject, Message.MainDateTime, Message.AttachmentCount, Mailbox.MailboxPath HAVING [From] LIKE '%something%' OR [To] LIKE '%something%' OR [Subject] LIKE '%something%' OR RecID in (select RecID from Message where Message.MessageBody like '%something%') OR RecID in (select MailID from Attachment where Attachment.AttachmentName like '%something%') ORDER By [Att.] DESC, [Subject] DESC

If Something is in one of the fields then nothing is found. The same functionality works for Snow Leopard as I just checked. Using Valentina 4.8.1.

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals