Because in phpMyAdmin the "propose a table structure" function is not coherent?

0

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

    
asked by anonymous 05.02.2018 / 21:36

0 answers