mysql-列的数据被截断

1 row affected. Warning: #1265 Data truncated for column 'value' at row 1

因为我的话就是这样

    CREATE TABLE IF NOT EXISTS `setting` (
  `setting_id` int(11) NOT NULL,
  `store_id` int(11) NOT NULL DEFAULT '0',
  `group` varchar(32) COLLATE utf8_bin NOT NULL,
  `key` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
  `value` text COLLATE utf8_bin NOT NULL,
  `serialized` tinyint(1) NOT NULL
) ENGINE=MyISAM AUTO_INCREMENT=28279 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

我尝试放置大约5000个数据,当我尝试插入其说的错误数据时,我可以输入大约2000个数据.

顺便说一句,因为您实际上是在列中存储二进制数据. MEDIUMBLOB实际上可能是一个更好的选择.

最后但并非最不重要的 ：

http://dev.mysql.com/doc/refman/5.7/en/miscellaneous-optimization-tips.html

With Web servers, store images and other binary assets as files, with
the path name stored in the database rather than the file itself. Most
Web servers are better at caching files than database contents, so
using files is generally faster. (Although you must handle backups and
storage issues yourself in this case.)