I remember versions of mysql whose string indexing was sufficiently limited on every available backend that this would've been the correct change.

Hell, back in ... 2001? I think? I ended up making exactly the same set of changes to an early database design of mine, for pretty much the same stated reasons and with very similarly pleasant effects on its performance.