If you insert a value that is not in the list, a blank value will be inserted. It contains 65535 values in an ENUM list. It is used when a string object having only one value, chosen from a list of possible values. It holds a string with a maximum length of 4,294,967,295 characters. It holds a string with a maximum length of 16,777,215. It holds a string with a maximum length of 255 characters. It holds a string that can contain a maximum length of 255 characters. Its size parameter specifies the maximum column length in bytes. It is equal to VARCHAR() but stores binary byte strings. Its size parameter specifies the column length in the bytes. It is equal to CHAR() but stores binary byte strings. Its size can be from 0 to 65535 characters.

It is used to specify a variable length string that can contain numbers, letters, and special characters. It is used to specify a fixed length string that can contain numbers, letters, and special characters. For example, in a particular column of a table, if we want to store a string type of data then we will have to declare a string data type of this column.ĭata types mainly classified into three categories for every database.ĭata Types in MySQL, SQL Server and Oracle Databases MySQL Data TypesĪ list of data types used in MySQL database.

Data types are used to represent the nature of the data that can be stored in the database table.

Sql server data types