I have 2 tables with fields and types EQUAL:
in Windows 2012 / php v5.6 mysql v5.6.38 with MyISAM latin1_general_ci
and in Linux 5.2 / php v7.1 mysql v5.6.38 with MyISAM utf8mb4_unicode_ci
When you click to propose a table structure, the proposals are very different:
Campos no Windows/php:
data = timestamp => proposta char(19)
A = varchar(65) => proposta Tinytext
B = varchar(200) => proposta Tinytext
C = smallint(1) => proposta Enum("1")
Campos no Linux/php:
TODOS os tipos da tabela: numéricos, varchar, text etc. são propostos para ENUM()
Questions:
1) Why are the proposals so different?
2nd) Do these proposals bring real performance improvements?
3rd) Or do I disregard the suggestions and use the "standard" types (smallint, char, varchar, text etc)?
Thanks in advance to everyone