1、查看当前数据库的编码
show variables like 'character_set_%';
输出如下:
----------------------------------------------------------------------
'character_set_client', 'utf8'
'character_set_connection', 'utf8'
'character_set_database', 'utf8'
'character_set_filesystem', 'binary'
'character_set_results', 'utf8'
'character_set_server', 'utf8'
'character_set_system', 'utf8'
'character_sets_dir', 'D:\Program Files\MySQL\MySQL Server 5.5\share\charsets\'
2、查看某表的所有列
show full columns from photo_image;
3、修改数据库、表、列
alter database upub character set utf8;
alter table photo_image character set utf8;
alter table photo_image modify image varchar(100) CHARACTER SET utf8;