Error when changing the data type of a column by the interface

Asked

Viewed 146 times

-1

I try to change the type of data VARCHAR for another type of data by the system interface (I don’t want to change via SQL) but I can’t.

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 field_int from VARCHAR(100) to INT(11), but I did not find the option to remove the charset and collation for the field. I don’t want to use SQL for this, I want to modify by the Dbeaver interface. How should I proceed?

Erro ocorrido

Interface do DBeaver

database character-encoding collation dbeaver

  • The simple fact of switching to INT should already eliminate both. If you had a problem trying the change, click [Dit] and describe in the post, then it is easier to find a solution.

  • Good morning friend changed the image, really was to accept the change when changing the data type to INT

1 answer

0


After contacting the Dbeaver developer "Serge-rider" he reported that it was a system bug and the fix has been made. It really is great software.

Browser other questions tagged database character-encoding collation dbeaver

You are not signed in. Login or sign up in order to post.