<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><br></div>First thing to try is reindex your db<div>Also look at the diagnose command at 'very high' level</div><div><br></div><div>hth</div><div><br></div><div>Bart<br><div><div>On 25 Aug 2012, at 07:33, George Parkinson wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10pt"><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">hello all,</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; ">can someone explain how the following occurs...</div><div style="font-family: arial, helvetica, sans-serif; font-size: 10pt; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal; ">(encoding is utf-8)</div><div style="font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal; ">table t1 has a single field f1, string(188) </div><div style="font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; color: rgb(0, 0, 0); background-color: transparent;
font-style: normal; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal; ">SELECT f1 FROM t1 WHERE f1= <a 188 character string></div><div style="font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal; ">will find the record...no problem.</div><div style="font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal; "><br></div><div style="font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; color: rgb(0, 0, 0); background-color: transparent; font-style: normal; ">however, <span style="background-color: transparent; ">when i have f1 indexed</span></div><div style="background-color: transparent; "><div style="color: rgb(0, 0, 0);
font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; ">f1, string(188) INDEXED</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; ">SELECT f1 FROM t1 WHERE f1= <the same 188 character string></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; ">will NOT find the record.</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><br></div><div style="color: rgb(0, 0, 0);
font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><span style="background-color: transparent; ">using 4.9.1 and e</span><span style="background-color: transparent; ">ncoding is utf-8 so as to have a 255 byte index limit.</span></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><span style="background-color: transparent; ">running in livecode, or in vstudio, the result is the same.</span></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><span style="background-color: transparent; "><br></span></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal;
background-color: transparent; "><span style="background-color: transparent; ">so, what am i missing?</span><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; ">many thanks,</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; ">george</div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color:
transparent; ">ps - for what it's worth, the field consists of 188 character strings like...</div><div style="background-color: transparent; "><font face="arial, helvetica, sans-serif"><span style="font-size: 10px; ">318d03035222210490000I00321121122100012022121211221009832666112016=4111053162221052130200000000000200020020020020100000000000000000000000000000000000000001121111212271121221122122122211121</span></font><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><br></div><div style="color: rgb(0, 0, 0); font-family: arial, helvetica, sans-serif; font-size: 13.600000381469727px; font-style: normal; background-color: transparent; "><br></div><br class="Apple-interchange-newline"></div></div></div>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></blockquote></div><br></div></body></html>