Subject Re: Index on character type column: CHAR or VARCHAR ?
Author Svein Erling Tysvær
--- In, "Alan McDonald" wrote:
> Someone will correct me if I'm wrong but indexes are limited to 128
> bytes,

OK, since you ask so kindly - I will correct you: Fields up to around
252 bytes (give or take a few, Ann amongst others know the exact
number) can be indexed, but assign a character set and each character
starts taking two or three bytes and you are may end up with not being
able to index a field of type (VAR)CHAR(85).