Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


mysqlerror specified key was too long max key length is 1000 bytes


mysqlerror specified key was too long max key length is 1000 bytes  using -'mysql,sql,ruby-on-rails,indexing,mysql-error-1071'

script/generate acts_as_taggable_on_migration
rake db:migrate


causes

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`)


What should I do?

Here is my database encoding:

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)

    

asked Sep 29, 2015 by sameer rathore
0 votes
7 views



Related Hot Questions



Walkin Jobs Opening



Government Jobs Opening


...