# 查看数据库和数据库表中编码集 show CREATE database newdjangodb; show CREATE table newdjangoapp_department ; show CREATE table newdjangoapp_userinfor; # 查看表信息 desc newdjangodb.django_migrations; # 查看编码信息 show character set ; # 修改表编码集 alter table newdjangoapp_department character set ='utf8' collate utf8_unicode_ci; # 查看表中字段编码 show full columns from newdjangoapp_userinfor; # 修改表中字段编码 alter table newdjangoapp_userinfor change name name varchar(32) character set utf8 collate utf8_unicode_ci not null default ''; alter table newdjangoapp_userinfor change password password varchar(32) character set utf8 collate utf8_unicode_ci not null default ''; # 修改表中字段属性编码集 alter table newdjangoapp_department change title title varchar(32) character set utf8 collate utf8_unicode_ci not null default ''; # 向表中插入数据 insert into newdjangoapp_department(title) values('销售');
mysql编码问题
最新推荐文章于 2024-04-17 11:23:23 发布