MySQL错误未知排序规则 [英] MySQL error unknown collation
本文介绍了MySQL错误未知排序规则的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
尝试在Laravel 4中运行迁移后,我收到以下错误:
After attempting to run a migration in Laravel 4 I received the following error:
[PDOException]
SQLSTATE[HY000]: General error: 1273 Unknown collation: ''
这是我的数据库连接配置;
Here is my database connection configuration;
'mysql' => array(
'driver' => 'mysql',
'host' => 'localhost',
'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',
'database' => 'database',
'username' => 'root',
'password' => 'root',
'charset' => 'utf8',
'prefix' => '',
),
有什么建议吗?
推荐答案
通过从安装的根文件夹中运行composer update来获取最新的源代码.否则,按如下所示更新您的阵列.
Grab the latest source code by running composer update from the root folder of your installation. Else update your array as below.
'mysql' => array(
'driver' => 'mysql',
'host' => 'localhost',
'unix_socket' => '/Applications/MAMP/tmp/mysql/mysql.sock',
'database' => 'database',
'username' => 'root',
'password' => 'root',
'charset' => 'utf8',
'collation' => 'utf8_unicode_ci',
'prefix' => '',
),
这篇关于MySQL错误未知排序规则的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文