On Tue, Apr 29, 2008 at 5:12 AM, C.R.Vegelin <[EMAIL PROTECTED]> wrote: > Hi All, > > I have a dictionary table like: > CREATE TABLE IF NOT EXISTS `mydictionary` > ( > `EN` varchar(36) default NULL, > `DE` varchar(36) default NULL, > `ES` varchar(36) default NULL, > `FR` varchar(36) default NULL, > `IT` varchar(36) default NULL, > `NL` varchar(36) default NULL, > `PT` varchar(36) default NULL, > KEY `EN` (`EN`), > KEY `DE` (`DE`), > KEY `ES` (`ES`), > KEY `FR` (`FR`), > KEY `IT` (`IT`), > KEY `NL` (`NL`), > KEY `PT` (`PT`) > ) ENGINE=MyISAM DEFAULT CHARSET = UTF8; > > When I run the query: > EXPLAIN SELECT `EN`, `FR` FROM `mydictionary` > WHERE `FR` Like "comp%" ORDER BY `FR`; > > EXPLAIN says: > select type = SIMPLE, type = range, key = FR, > key-len = 111, ref = NULL, extra = using where > > Any idea why key-len is 111 ? > > Thanks, Cor > >
Your using a multi byte character set. -- Rob Wultsch [EMAIL PROTECTED] wultsch (aim) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]