How to set a varchar to have unlimited length?

Question

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?

Answer 1

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

To store large data in Mysql database you can use

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) 

Answer 2

You can try using varchar(max)