如何设置字符集utf8和表行排序在PHP mysql查询 - How can Set character set utf8 and table rows collation in PHP mysql with query

How can Set character set utf8 and table rows collation in PHP mysql with query

我想在PHP mysql中动态地制作表，并在表中设置字符集utf8及其行排序utf8_general_ci。我没有线索

有人来帮忙吗?

下面是我的create table查询:

CREATE TABLE `Table name` (
              `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
              `First name` TEXT( 9 ) NOT NULL,
              `Last name` TEXT NOT NULL,
              `email` TEXT NOT NULL,
              UNIQUE KEY id (id)
            );

如何在查询中设置"utf8"参数?

试试这个名称

CREATE TABLE `Table name` (
              `id` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
              `First name` TEXT( 9 ) NOT NULL COLLATE 'utf8_general_ci',
              `Last name` TEXT NOT NULL COLLATE 'utf8_general_ci',
              `email` TEXT NOT NULL COLLATE 'utf8_general_ci',
              UNIQUE KEY id (id)
            )COLLATE='utf8_general_ci';

不要对int、float数据类型进行排序