difference between char, varchar, and text types
char and varchar required a certain number about (e.g. varchar(20)), text does not. Text is for large text, char is for tiny and unvariable text (male, female), for a large variety in length of text use varchar. The difference is memory allocation or in other words, speed.