Menu

MySQL String Data Types

MySQL String Data Types

In this tutorial, we will learn about MySQL String Data Types. Strings are an important data type. A String is used for storing character strings. A character string is a sequence of characters.

String data types

String data types provided in MySQL are as follows.

  • CHAR
  • VARCHAR
  • TINYTEXT
  • TEXT
  • MEDIUMTEXT
  • LONGTEXT

 

 

String Data Type
 Description
CHAR CHAR data type is for fixed-length strings. Fixed-length means that a string is stored using a fixed number of bytes. It is right-padded with spaces to the specified length when stored.
VARCHAR VARCHAR data type is for variable-length strings. Variable-length stores the string value and string length together. The amount of storage space that VARCHAR uses depends on the number of characters in the string
TINYTEXT TINYTEXT data type is for variable-length strings and allows up to a maximum of 255 characters
TEXT The TEXT data type is used for variable-length strings and allows up to a maximum of 65,535 characters
MEDIUMTEXT MEDIUMTEXT data type is for variable-length strings and allows up to a maximum of 16,777,215 characters
LONGTEXT LONGTEXT data type is for variable-length strings and allows up to a maximum of 4,294,967,295 characters. The maximum permitted length depends on the client/server protocol

 

 

 

MySQL Tutorials

MySQL Tutorials on this website:

https://www.testingdocs.com/mysql-tutorials-for-beginners/

 

Related Posts

MySQL COALESCE() Function

MySQL COALESCE() Function The COALESCE() function in MySQL returns the first non-null value from a list of expressions. If all arguments are NULL, it returns NULL. Syntax COALESCE(expr1, expr2, …, exprN) expr1, expr2, …, exprN: These are the expressions to evaluate. The function returns the first non-null expression from this list. It requires at least […]

MySQL Configurator Tool

MySQL Configurator Tool

MySQL Configurator Tool MySQL Configurator tool allows you to configure and optimize MySQL installations for better performance, security, and functionality. It simplifies the setup process, especially for those who are new to MySQL or need to tailor configurations to specific requirements. Features of MySQL Configurator Some of the features of the tool are as follows: […]