What datatype to use in mysql?

Question

MySQL

In general, there is a field where data up to 2000 characters long can be entered. What type of data to use for storage? It is also fundamentally important to be able to set a default value (which does not work in text fields for some reason).

Answer 1

Every table (regardless of storage engine) has a maximum row size of 65,535 bytes. Storage engines may place additional constraints on this limit, reducing the effective maximum row size.

According to the link, everything quite reaching is explained dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
If briefly, the total number of field types should not exceed 64kb.
Text + blob field types are not taken into account
. In your case, you need to use TEXT BLOB for text
. The default value can be set at the code level.

Answer 2

The VARCHAR type can be up to 65,535 in length as of version 5.0.3.
And when creating a table, the default value is normally set
City VARCHAR(40) NOT NULL DEFAULT 'Unknown'