为什么在MySQL数据列中仅保存64kB数据? [英] Why is only 64kB of data being saved in my MySQL data column?

问题描述

我试图在MySQL Blob列中插入一个很长的文本字符串，但是MySQL仅保存64kB的数据.字符串长度为75360个字符.我正在连接PHP的mysql_connect().

I am trying to insert a very long text string into a MySQL Blob column, but MySQL is only saving 64kB of the data. The string is 75360 characters long. I am connecting with PHP's mysql_connect().

有什么想法吗?

如果是Blob或Text，是否会有所不同.我最初以文本形式使用它，但是没有任何影响地对其进行了更改.

Does it make a difference if it's Blob or Text. I originally had it as a Text but changed it with no affect.

推荐答案

因为这是 BLOB列的最大大小.您需要使用MEDIUMBLOB/LONGBLOB或MEDIUMTEXT/LONGTEXT.

Because that's the maximum size of a BLOB column. You need to use MEDIUMBLOB/LONGBLOB or MEDIUMTEXT/LONGTEXT.

这篇关于为什么在MySQL数据列中仅保存64kB数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！