On Fri, Sep 12, 2008 at 9:27 AM, Roan Kattouw <roan.kattouw(a)home.nl> wrote:
Watch out for multibyte collations there. In the past,
MW has had
numerous issues with multibyte collations causing index lengths to
almost double up and hit the limit.
VARBINARY doesn't have collations. Which is part of why we use it for
everything. (Well, that and because Wikipedia runs on 4.0, which
doesn't have collations for anything. :) ) A utf8 collation will
triple the maximum size of the index, yes.