> Now by our reconing the key of the > fields is 343 bytes, encoding in UTF8 makes that key 343 bytes Not > 1000 > since under utf8 each character is encode in 8 bits. If it is > converting to > utf16 internally then the key would be 328*2+5+4 which is not >1000 > bytes. >
If you only use the ascii range of utf8 then you are right that you are only _storing_ 1 byte per character. Mysql, however, must still _reserve_ 3 bytes for each character because other languages require more bytes per character (up to six but I believe mysql only supports 3 bytes for utf8 characters right now). So using your count of 343 * 3 = 1029. The index prefix lengths, by the way, are in characters not bytes. best regards, Jeremy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
