如何在用PDO创建表时将表的排序规则设置为utf8_persian_ci

Question

我想通过PDO在Mysql数据库中创建几个表。

我使用以下代码：

$db = new PDO('mysql:host='.$servername.'; dbname='.$db , $username, $password);
$sql = "CREATE TABLE IF NOT EXISTS d1
(
  Course_name VARCHAR(200) NOT NULL,
  course_start INT(5) NOT NULL,
  course_row INT(22) NOT NULL,
  id INT NOT NULL AUTO_INCREMENT PRIMARY KEY
)";
$sq = $db->query($sql);

但是我有一个很大的问题:表排序规则必须是utf8_persian_ci或utf8_bin。如何在创建表的同时设置表的排序规则？

我有一个数据库，我想把它的排序规则也改成utf8_persian_ci或utf8_bin。怎么办？

Answer 1

这是我如何解决我的排序问题，支持匈牙利字符：

use szatmarihidegyesulet;
ALTER DATABASE szatmarihidegyesulet CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE admin_users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE article_items CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE articles CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE contacts CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE content_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE content_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE galleries CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE gallery_materials CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE materials CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE sources CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE tags CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

除了您自己的表之外，您也可以做同样的事情。我不知道在创建表时如何设置它，但您仍然可以更改它。