odd indexed string behaviour?

Sat Aug 25 09:57:13 CDT 2012

First thing to try is reindex your db
Also look at the diagnose command at 'very high' level

hth

Bart
On 25 Aug 2012, at 07:33, George Parkinson wrote:

> hello all,
> can someone explain how the following occurs...
> 
> (encoding is utf-8)
> table t1 has a single field f1, string(188) 
> 
> SELECT f1 FROM t1 WHERE f1= <a 188 character string>
> will find the record...no problem.
> 
> however, when i have f1 indexed
> f1, string(188) INDEXED
> 
> SELECT f1 FROM t1 WHERE f1= <the same 188 character string>
> will NOT find the record.
> 
> using 4.9.1  and encoding is utf-8 so as to have a 255 byte index limit.
> running in livecode, or in vstudio, the result is the same.
> 
> so, what am i missing?
> 
> many thanks,
> george
> 
> ps - for what it's worth, the field consists of 188 character strings like...
> 318d03035222210490000I00321121122100012022121211221009832666112016=4111053162221052130200000000000200020020020020100000000000000000000000000000000000000001121111212271121221122122122211121
> 
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120825/69252ce9/attachment.html>