yiichina
初始化的数据库类型为utf8mb4 时会报错
m130524_201442_init 里面如果设置数据库为$tableOptions = 'CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ENGINE=InnoDB'; 会报下面的错误；
Apply the above migrations? (yes|no) [no]:yes *** applying m130524_201442_init
create table {{%user}} ...Exception 'yii\db\Exception' with message 'SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes The SQL being executed was: CREATE TABLE user ( id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(255) NOT NULL UNIQUE, auth_key varchar(32) NOT NULL, password_hash varchar(255) NOT NULL, password_reset_token varchar(255) UNIQUE, email varchar(255) NOT NULL UNIQUE, status smallint(6) NOT NULL DEFAULT 10, created_at int(11) NOT NULL, updated_at int(11) NOT NULL ) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci ENGINE=InnoDB'
in E:\Code\richin-cms\vendor\yiisoft\yii2\db\Schema.php:664
Error Info: Array ( [0] => 42000 [1] => 1071 [2] => Specified key was too long; max key length is 767 bytes )
