Organizational Research By

Surprising Reserch 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
14 views



Related Hot Questions

4 Answers

0 votes
NULL
answered Sep 29, 2015 by bhavin
0 votes
NULL
answered Sep 29, 2015 by girisha
0 votes
NULL
answered Sep 29, 2015 by mca.agarwal
0 votes
NULL
answered Sep 29, 2015 by tushar2k6

...