Create a ENUM-type like data type that does string compression (at a scale). For
example, create a type LOOKUP(255) CHARSET utf8. We store browser user-agent
strings here, you store bigint unsigned numbers internally, and create a lookup
structure so that each occurrence of a string is physically stored only once.
Convert from VARCHAR to LOOKUP using ALTER TABLE.

Observers changed: Sergei