I have a problem using laravel migrate command. It shows :
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))
But my mysql version is 5.7.14 and my charset is :
mysql> show variables like "%char%"; +--------------------------+-------------------------------------------------+ | Variable_name | Value | +--------------------------+-------------------------------------------------+ | character_set_client | utf8mb4 | | character_set_connection | utf8mb4 | | character_set_database | utf8mb4 | | character_set_filesystem | binary | | character_set_results | utf8mb4 | | character_set_server | utf8mb4 | | character_set_system | utf8 | | character_sets_dir | D:\wamp64\bin\mysql\mysql5.7.14\share\charsets\ | +--------------------------+-------------------------------------------------+
So there should not be any problem as doc said. Someone can help me?
via DengDeng
