I must search on a tinytext field. I want to put an index on it to make it faster. but i have to specify the size for that index.
MySql says this: "....Note that prefix limits are measured in bytes, whereas the prefix length in CREATE TABLE statements is interpreted as number of characters...."
Ok so how do i calculate the number of bytes needed to get a good index on a tinytext field knowing that smaller is better? My Character set is in UTF-8.