mysql5.5
发布网友
发布时间:2022-05-07 14:06
我来回答
共1个回答
热心网友
时间:2022-05-07 15:35
字符编码问题。
SET NAMES 'utf8';
它相当于下面的三句指令:
SET character_set_client = utf8;
SET character_set_results = utf8;
SET character_set_connection = utf8;
修改数据库成utf8的.
mysql> alter database name character set utf8;
修改表默认用utf8.
mysql> alter table type character set utf8;
修改字段用utf8.
mysql> alter table type modify type_name varchar(50)
CHARACTER SET utf8;