如何将varchar设置为无限制长度? [英] How to set a varchar to have unlimited length?

问题描述

在MySQL数据库中，如何将varchar设置为无限制长度，以便可以存储较长的网页?如果不是，那么最大大小是多少?

In a MySQL database, how would I set a varchar to have unlimited length, so that I can store long web pages? IF not , then what is the Maximum Size?

我知道用于存储较大字符串的文本类型.使用我必须处理的测试数据类型有任何限制吗?

I know about Text Types to store larger strings. Is there any limitations on using test data type which i have to handle?

推荐答案

在MySQL 5.0.3之前，VARCHAR最多可以存储255个字符，而在5.0.3及更高版本中，VARCHAR可以存储65,535个字符.

VARCHAR can store upto 255 chars before MySQL 5.0.3 and 65,535 chars in 5.0.3 and later versions.

要在Mysql数据库中存储大数据，可以使用

To store large data in Mysql database you can use

TEXT，MEDIUMTEXT，LONGTEXT

TEXT , MEDIUMTEXT , LONGTEXT

TEXT can store 65,535 characters (approx 64KB)
MEDIUMTEXT = 16,777,215 characters (approx 16 MB) 
LONGTEXT = 4,294,967,295 chars (approx 4GB)

这篇关于如何将varchar设置为无限制长度?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！