Question: what is the difference between varchar and text in mysql?
Answer: TEXT has a fixed max size of 2¹⁶-1 = 65535 characters. VARCHAR has a variable max size M up to M = 2¹⁶-1 . The other difference is, that you cannot put an index (except for a fulltext index) on a TEXT column. So if you want to have an index on the column, you have to use VARCHAR.