insert into dcr_data(cardid,zcid,czmoney,fcbl,tc) values('m10515993755','尛丶羙','0','1','0') mysql提示错误为:Data too long for column 'zcid' at row 1 zcid为:VARCHAR(50) 为什么会说太长了?我的表用了gb2312 但用gbk也没用 utf8也没用
解决方案 »
- PRIMARY KEY ,UNIQUE KEY ,KEY
- mysql 日志文件的状态为什么总是OFF
- mysql里面的date怎么才能只取年月日
- MySQL function的问题
- 感觉人生的尽头了,实在是太难了,做不出来,不想在IT混了
- 哪位大虾知道有什么介绍mysql存储管理、查询管理、事务管理、系统恢复的书或者资料的???急啊!!!谢谢了~~
- 新手上路,请大虾推荐几本经典的书!!
- 关于gb2312.conf的问题
- >MYSQL,别处还有好的论坛去处吗?谢谢!!<
- MYSQL支持中文和日文全文索引的解决方案有哪些呢?
- mysqldumpslow
- 关于mysql安装,注册表里的有mysql的项都给删除,显示“配置文件已经损坏,请联系供货商”
MySQL 中文显示乱码
插入的sql语句为:insert into dcr_data(cardid,zcid,czmoney,fcbl,tc) values('m10583548748','大蒜头2','15','1','15')插入数据['m10522986068','小不點灬','15','1','15']失败,mysql提示错误为:Data too long for column 'zcid' at row 1
插入的sql语句为:insert into dcr_data(cardid,zcid,czmoney,fcbl,tc) values('m10522986068','小不點灬','15','1','15')
show create table dcr_data;提供你的信息。
+--------------------------+----------------------------------------------------
---+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
---+
| character_set_client | gbk
|
| character_set_connection | gbk
|
| character_set_database | gbk
|
| character_set_filesystem | binary
|
| character_set_results | gbk
|
| character_set_server | gbk
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5\share\charset
s\ |
+--------------------------+----------------------------------------------------
---+
表格式为:
CREATE TABLE `tg`.`dcr_data` (
`id` int(10) NOT NULL auto_increment,
`cardid` varchar(50) character set gb2312 NOT NULL default '',
`zcid` varchar(50) character set gb2312 NOT NULL default '',
`czmoney` double NOT NULL default '0',
`fcbl` double NOT NULL default '0',
`tc` double NOT NULL default '0',
`addtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;