0

I have one table in MySQL where I would like to change the "Data type" of two columns in DBeaver (version 22.3.4). The two columns are MD_Estimated and BL_Estimated as you can see in this image:

enter image description here

However, when I save the changes, this is the code which is run:

ALTER TABLE Kruda_Denta_Datumbazo.CrownDiameterTable MODIFY COLUMN MD_Estimated BOOL NULL;
ALTER TABLE Kruda_Denta_Datumbazo.CrownDiameterTable MODIFY COLUMN BL_Estimated BOOL NULL;

But the problem is that it does not return any error, but the "Data type" is not saved as BOOL, but as tinyint(1), as you can see in this image:

enter image description here

Am I doing something wrong?

antecessor
  • 2,688
  • 6
  • 29
  • 61
  • 1
    Does this answer your question? [Which MySQL data type to use for storing boolean values](https://stackoverflow.com/questions/289727/which-mysql-data-type-to-use-for-storing-boolean-values) – P.Salmon Feb 19 '23 at 09:25

1 Answers1

1

TINYINT(1) and boolean are synonymous In MySQL. Bool is converted to TINYINT(1) under the hood.

protob
  • 3,317
  • 1
  • 8
  • 19