mysql error 1000_Mysql :: Error：指定的键太长;最大密钥长度为1000字节

script/generate acts_as_taggable_on_migration

rake db:migrate

原因

Mysql::Error: Specified key was too long; max key length is 1000 bytes: CREATE INDEX `index_taggings_on_taggable_id_and_taggable_type_and_context` ON `taggings` (`taggable_id`, `taggable_type`, `context`)

我该怎么办？

这是我的数据库编码：

mysql> SHOW VARIABLES LIKE 'character\_set\_%';

+--------------------------+--------+

| Variable_name | Value |

+--------------------------+--------+

| character_set_client | latin1 |

| character_set_connection | latin1 |

| character_set_database | utf8 |

| character_set_filesystem | binary |

| character_set_results | latin1 |

| character_set_server | latin1 |

| character_set_system | utf8 |

+--------------------------+--------+

7 rows in set (0.00 sec)