text

Introduction

Unlike the CHAR and VARCHAR types, when using the TEXT type, you do not have to specify the storage length.

MySQL provides four TEXT types:

• TINYTEXT -TEXT
• MEDIUMTEXT
• LONGTEXT

TINYTEXT

Length is 255 bytes (255 characters)

TEXT

Length is 64KB (65,535 characters)

Examples include storing articles from news websites and product descriptions from e-commerce websites.

MEDIUMTEXT

Length is 16MB (16,777,215 characters)

LONGTEXT

Length is 4GB (4,294,967,295 characters)

Verify TEXT type

Luwak checks the length to meet the maximum number of characters the column can store.

Please refer to the char type.