Case-insensitive searches with Lion

[Stan Busk]

It seems I have the same problem here. I have received a report of a client using Lion and searches are all of a sudden case-sensitive. :-/

Stan

> 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
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina