为什么Rails将TEXT列截断为65535个字符? [英] Why is rails trucating TEXT column to 65535 chars?

问题描述

我正在使用Ruby on Rails将原始电子邮件保存在MySQL的TEXT列中.它一直被截断为65535个字符，有人知道是什么原因造成的吗?

I am saving a raw email in a TEXT column in MySQL with Ruby on Rails. It keeps getting truncated to 65535 characters, does anyone know what causes this?

MySQL使用max_allowed_packet=64M

使用InnoDB作为存储引擎.

Using InnoDB for the storage engine.

推荐答案

它被截断为该长度，因为...好吧，.

It gets truncated to that length because... well, that's what will fit in a TEXT column.

如果要存储更多内容，则需要MEDIUMTEXT或LONGTEXT.

You need MEDIUMTEXT or LONGTEXT if you want to store more than that.

这篇关于为什么Rails将TEXT列截断为65535个字符?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！