odd indexed string behaviour?

[George Parkinson]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120824/1dfa14fe/attachment.html>