I try to change the data type from VARCHAR
to another data type through the system interface (I do not want to change via SQL) but I can not.
I have the following table created:
CREATE TABLE 'Usuarios' (
'id_usuario' int(11) NOT NULL AUTO_INCREMENT,
'nome' varchar(100) DEFAULT NULL,
'sobrenome' varchar(100) DEFAULT NULL,
'documento' varchar(100) DEFAULT NULL,
'data_nascimento' date DEFAULT NULL,
'campo_int' varchar(100) DEFAULT NULL,
PRIMARY KEY ('id_usuario')
) ENGINE=InnoDB DEFAULT CHARSET=utf8
And I would like to change the_int field from VARCHAR (100) to INT (11), but I did not find the option to remove the charset and collation for the field. I do not want to use SQL for this, I want to modify it through the DBeaver interface. How should I proceed?