MySQL Basics-Character types

Types of characters supported by MySQL:

type	size	Use
CHAR	0-255 bytes	Fixed length string
VARCHAR	0-65535 bytes	Variable length string
Tinyblob	0-255 bytes	A binary string of no more than 255 characters
Tinytext	0-255 bytes	Short text string
Blob	0-65 535 bytes	Long text data in binary form
TEXT	0-65 535 bytes	Long Text data
Mediumblob	0-16 777 215 bytes	Medium-length text data in binary form
Mediumtext	0-16 777 215 bytes	Medium-Length text data
Longblob	0-4 294 967 295 bytes	Large text data in binary form
Longtext	0-4 294 967 295 bytes	Maximum text data

MySQL Basics-Character Types