Searching for long strings

[Ruslan Zasukhin]

On 4/23/12 11:06 AM, "Beatrix Willius" <bwillius at gmx.de> wrote:

> Why does the following query give me a result even if it shouldn't?
> 
> select RecID, * from mailbox where MailboxPath
> ='Mailboxes:Macci:Users:beatrixwillius:Library:Mail:V2:Mailboxes:Importiert.mb
> ox:Test Mails.mbox:mime mails.mbox:BB999085-B00E-491A-832B-8E9334DC2999:Data'
> 
> Only the mailboxes up to
> 
> Mailboxes:Macci:Users:beatrixwillius:Library:Mail:V2:Mailboxes:Importiert.mbox
> :Test Mails.mbox:mime mails.mbox:BB999085-B00E-491A-832B-8E9334DC2999
> 
> without the Data folder are in the database, which is also the result shown.
> Occurs both in RB code and in VStudio.
> 
> Using beta 20 with RB2011r4, Mac OS 10.7.2 and Cocoa.

Hi Beatrix,

Beta beta beta list  if we talking about beta,


Please mantis such db ...
We need check to better answer ...


For now only come to mind limit on max string that is indexed is 255 bytes
-- 128 chars UTF16


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]