(1)在客户端终于可以看到中文文字符了!

以前用jdbc填写的数据,在命令行客户端显示总是乱码,原来设置一下字符集就可以了!菜鸟啊,我把mysql字符集的一些设置命令贴出来:    
[client]
SET character_set_results=gbk;
SET character_set_connection=utf8;
SET character_set_client=gbk;
SET character_set_server=gbk;
SET character_set_database=utf8;

(2)Data truncation: Data too long for column错误解决办法是:
牢记:
CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name

[create_specification [, create_specification] ...]

create_specification:

[DEFAULT] CHARACTER SET charset_name

| [DEFAULT] COLLATE collation_name

如:create database mydb CHARACTER SET gbk;
(3)其他统一用utf8就可以.