I have a Joomla! table:
CREATE TABLE `jos_messages_cfg` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`cfg_name` text NOT NULL,
`cfg_value` text NOT NULL,
UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`(100))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
MySQL compare doesn't recognise the UNIQUE KEY column length.
Which results in:

Thoughts:
- It should pick up the UNIQUE KEY correctly
- It's a shame it's not possible to copy the error from this error dialog
- Errors do NOT result in an option of a re-compare
MySQL compare doesn't recognise the UNIQUE KEY column length.
Which results in:
Thoughts: