<html><body><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></body></html>