Jakub Hegenbart wrote:

> Is it possible to overcome the limit with creating an extra column with
> a truncated version of the field that gets inserted/updated using a
> trigger and can be indexed due to its length?

Yep. That works fine where MySQL provides an index on a large TEXT
field, but there are never more than 30 characters in the contents, so
the trigger just copies the first 32 characters to a VARCHAR and I index
on that :)

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services