Case-insensitive searches with Lion

[Thorsten Hohage]

Just out of interest, are you able to check this against a VServer?

Because my first test shows no such errors on Vserver, but several other strange things on local usage. 

Sent from my iPhone

On 02.08.2011, at 09:45, Beatrix Willius <bwillius at gmx.de> wrote:

> 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
>