feat: support BOOLEAN column type in MySQL

ansgarbecker · ansgarbecker · commit e796ad1d55a4 · 2026-02-19T18:45:48.000+01:00
Closes #1541
diff --git a/source/dbstructures.mysql.pas b/source/dbstructures.mysql.pas
@@ -332,7 +332,7 @@   TMySqlProvider = class(TSqlProvider)
 
 
   // MySQL Data Type List and Properties
-  MySQLDatatypes: array [0..41] of TDBDatatype =
+  MySQLDatatypes: array [0..42] of TDBDatatype =
   (
     (
       Index:           dbdtUnknown;
@@ -361,6 +361,19 @@   TMySqlProvider = class(TSqlProvider)
       LoadPart:        False;
       Category:        dtcInteger;
     ),
+    (
+      Index:           dbdtBool;
+      NativeType:      1;
+      Name:            'BOOLEAN';
+      Description:     'Synonym of TINYINT(1)';
+      HasLength:       False;
+      RequiresLength:  False;
+      MaxSize:         127;
+      HasBinary:       False;
+      HasDefault:      True;
+      LoadPart:        False;
+      Category:        dtcInteger;
+    ),
     (
       Index:           dbdtSmallint;
       NativeType:      2;
