mysql怎么定义中文类型

-- 创建一个包含VARCHAR类型字段的表
CREATE TABLE `users` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(50) NOT NULL,
  `address` VARCHAR(255)
);

-- 创建一个包含TEXT类型字段的表
CREATE TABLE `articles` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `title` VARCHAR(255) NOT NULL,
  `content` TEXT
);

-- 设置数据库字符集
ALTER DATABASE `your_database_name` CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

-- 设置表字符集
ALTER TABLE `your_table_name` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

-- 设置字段字符集
ALTER TABLE `your_table_name` MODIFY `your_column_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

// PHP示例
$mysqli = new mysqli("localhost", "user", "password", "database");
$mysqli->set_charset("utf8mb4");