在使用mysql的时候,插入中文,报错
ERROR 1366 (HY000): Incorrect string value: '\xE5\x8F\xA3\xE8\x85\x94' for column 'name' at row
我们可以在建表的时候带上编码:DEFAULT CHARSET 'utf8'
如:
CREATE TABLE `students`(
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(20) NOT NULL,
`nickname` VARCHAR(20) NULL,
`sex` CHAR(1) NULL,
`in_time` DATETIME NULL
) DEFAULT CHARSET 'utf8';
也可以修改表的编码
alter table students convert to character set utf8;
编码有问题,输入如下命令设置
set character_set_client = utf8;
set character_set_server = utf8;
set character_set_connection = utf8;
set character_set_results = utf8;
set collation_connection = utf8_general_ci;
set collation_database = utf8_general_ci;
set collation_server = utf8_general_ci;