- VARCHAR and CHAR, implementation depends on storage engine
- VARCHAR – variable length
- CHAR – fixed length:
- for example for MD5 hashes
- better then VARCHAR for masivelly changed data
- BLOB and TEXT – for large binary or text data
- whole family of types: TINYTEXT; SMALLTEXT (=TEXT); MEDIUMTEXT; LONGTEXT
- the same for BLOB
- mySQL cannot index whole content