title: MySQL using MATCH AGAINST for long unique values (8.0.27)
body: <p>I have a situation where we're storing long unique IDs (up to 200 characters) that are single TEXT entries in our database. The problem is we're using a FULLTEXT index for speed purposes and it works great for the smaller GUID style entries. The problem is it won't work for the entries &gt; 84 characters due to the limitations of innodb_ft_max_token_size, which apparently cannot be set &gt; 84. This means any entries more than 84 characters are omitted from the Index.</p>
  <p>Sample Entries (actual data from different sources I need to match):</p>
  <pre><code>AQMkADk22NgFmMTgzLTQ3MzEtNDYwYy1hZTgyLTBiZmU0Y2MBNDljMwBGAAADVJvMxLfANEeAePRRtVpkXQcAmNmJjI_T7kK7mrTinXmQXgAAAgENAAAAmNmJjI_T7kK7mrTinXmQXgABYpfCdwAAAA==
  </code></pre>
  <p>AND</p>
  <pre><code>&lt;j938ir9r-XfrwkECA8Bxz6iqxVth-BumZCRIQ13On_inEoGIBnxva8BfxOoNNgzYofGuOHKOzldnceaSD0KLmkm9ET4hlomDnLu8PBktoi9-r-pLzKIWbV0eNadC3RIxX3ERwQABAgA=@t2.msgid.quoramail.com&gt;
  </code></pre>
  <p>AND</p>
  <pre><code>[&quot;ca97826d-3bea-4986-b112-782ab312aq23&quot;,&quot;ca97826d-3bea-4986-b112-782ab312aaf7&quot;,&quot;ca97826d-3bea-4986-b112-782ab312a326&quot;]
  </code></pre>
  <p>So what are my options here? Is there any way to get the unique strings of 160 (or so) characters working with a FULLTEXT index?</p>
  <p>What's the most efficient Index I can use for large string values without spaces (up to 200 characters)?</p>