https://www.mysqltutorial.org › mysql-basics › mysql-text

This tutorial shows you how to use various MySQL TEXT data type such as TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT to store text data.

https://dev.mysql.com › doc › refman › 8.4 › en › string-type-syntax.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement.

https://www.sqlfacile.com › apprendre_bases_de_donnees › les_types_sql_texte

On peut, là encore, observer des différences entre les types MySQL et les types PostgreSQL.

https://www.w3schools.com › mysql › mysql_datatypes.asp

Learn about the different data types in MySQL, such as string, numeric, and date and time. TEXT is a string data type that can hold up to 65,535 characters.

https://dev.mysql.com › doc › refman › 8.4 › en › string-types.html

Learn about the string data types in MySQL, such as CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. See the syntax, storage requirements, and functions for each type.

https://dev.mysql.com › doc › refman › 8.4 › en › blob.html

The four TEXT types are TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These correspond to the four BLOB types and have the same maximum lengths and storage requirements. See Section 13.7, “Data Type Storage Requirements”. BLOB values are treated as binary strings (byte strings).

https://stackoverflow.com › questions › 11624807

BLOB and BINARY simply store bytes. BLOB is used for storing binary data while Text is used to store large string. BLOB values are treated as binary strings (byte strings). They have no character set, and sorting and comparison are based on the numeric values of the bytes in column values.

https://www.slingacademy.com › article › mysql-8-char-varchar-text-blob-data-types...

In this article, we delve into CHAR, VARCHAR, TEXT, and BLOB data types in MySQL 8 and provide examples so you can understand their use and differences. The CHAR Data Type CHAR is a fixed-length data type used to store character strings.

https://www.delftstack.com › fr › howto › mysql › mysql-varchar-vs-text

Ce tutoriel présente la différence entre VARCHAR et TEXT dans la base de données MySQL.

https://www.basedash.com › blog › guide-to-mysql-text-types

MySQL supports four primary text types: TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT. These types store non-binary string data, like articles, emails, or JSON objects, and mainly differ in storage capacity.