¿Para qué tipo de datos sería mejor utilizar el texto largo?

What type of data would long text be best used for?

TEXT objects are best used when VARCHAR and other string-based data objects are insufficient to handle storing the desired amount of information.

Datatype Limits

Long Text In Access web apps, the Long Text field can store up to 2^30-1 bytes, and is equivalent to the SQL Server data type of nvarchar(max). If you want, you can set a character limit to prevent your users from using the full capacity of the field. Its SQL Server equivalent is nvarchar, with length from 1 to 4000.

The LONG datatype is like the VARCHAR2 datatype, except that the maximum size of a LONG value is 32760 bytes. You use the LONG RAW datatype to store binary data or byte strings. LONG RAW data is like LONG data, except that LONG RAW data is not interpreted by PL/SQL. The maximum size of a LONG RAW value is 32760 bytes.

If something has a fixed length, we use char . If it has variable length with a well defined upper limit then use varchar . If it’s a big chunk of text that you have little control over then text would be probably your best bet.

CHAR data type
The CHAR data type stores any string of letters, numbers, and symbols. It can store single-byte and multibyte characters, based on the database locale.

DO NOT use VARCHAR(MAX) just because it can be. Use it only if the data to be stored can be more than 8,000 bytes.

Long answer: There is essentially no difference (in MySQL) between VARCHAR(3000) (or any other large limit) and TEXT .

Best practice for storing long text fields. As we all know, there is a 8060 bytes size limit on SQL Server rows. have a table which requires a number of text fields (5 or 6). these text fields should support a max of 4000 characters.

From the docs: ntext, text, and image data types will be removed in a future version of Microsoft SQL Server. Avoid using these data types in new development work, and plan to modify applications that currently use them. Use nvarchar(max), varchar(max), and varbinary(max) instead.

If you’re using SQL Server 2005 or later, use varchar (MAX). The text datatype is deprecated and should not be used for new development work. From the docs: ntext , text, and image data types will be removed in a future version of Microsoft SQL Server.

The TINYTEXT data object is the smallest of the TEXT family and is built to efficiently store short information strings. This type can store up to 255 bytes (expressed as 2^8 -1) or 255 characters and requires a 1 byte overhead.