报错 1366或MySqlException (0x80004005)解决办法

insert into websites(id,name,url,alexa,country) VALUES
(2,‘淘宝’,‘https://www.google.cm/’,1,‘USA’),
(3,‘菜鸟教程’,‘https://www.taobao/’,1,‘USA’),
(4,‘微博’,‘https://www.google.cm/’,1,‘USA’),
(5,‘Facebook’,‘https://www.google.cm/’,1,‘USA’)

1366 - Incorrect string value: ‘\xE6\xB7\x98\xE5\xAE\x9D’ for column ‘name’ at row 1
时间: 0s
c#写了一个mysql插入语句，插入中文字符串时上报异常：
MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect string value。

这个问题，最终是通过这个方法解决的：
alter table mytablename convert to character set utf8mb4 collate utf8mb4_bin;

把存在字符编码冲突的表的字符编码，调整为utf8mb4格式。再次运行上面问题解决。

alter table websites convert to character set utf8mb4 collate utf8mb4_bin;
select * from websites
SELECT NOW();
insert into websites(id,name,url,alexa,country) VALUES
(2,‘淘宝’,‘https://www.google.cm/’,1,‘USA’),
(3,‘菜鸟教程’,‘https://www.taobao/’,1,‘USA’),
(4,‘微博’,‘https://www.google.cm/’,1,‘USA’),
(5,‘Facebook’,‘https://www.google.cm/’,1,‘USA’)