MySQL datatypes are mapped to the TFieldType in the following way:
| MySQL type | DbExpress type | Delphi type |
|---|
| TINYINT | ftSmallint | TSmallintField |
| TINYINT UNSIGNED | ftSmallint | TSmallintField |
| SMALLINT | ftSmallint | TSmallintField |
| SMALLINT UNSIGNED | ftSmallint | TSmallintField |
| MEDIUMINT | ftInteger | TIntegerField |
| MEDIUMINT UNSIGNED | ftInteger | TIntegerField |
| INT | ftInteger | TIntegerField |
| INT UNSIGNED | ftInteger | TIntegerField |
| BIGINT | ftFloat | TFloatField |
| BIGINT UNSIGNED | ftFloat | TFloatField |
| DOUBLE | ftFloat | TFloatField |
| FLOAT | ftFloat | TFloatField |
| DECIMAL | ftFloat | TFloatField |
| CHAR | ftString | TStringField |
| CHAR BINARY | ftString | TStringField |
| VARCHAR | ftString | TStringField |
| VARCHAR BINARY | ftString | TStringField |
| DATE | ftDate | TDateField |
| TIME | ftTime | TTimeField |
| TIMESTAMP | ftTimeStamp | TSQLTimeStampField |
| DATETIME | ftTimeStamp | TSQLTimeStampField |
| YEAR | ftInteger | TIntegerField |
| TINYBLOB | ftBlob | TBlobField |
| BLOB | ftBlob | TBlobField |
| MEDIUMBLOB | ftBlob | TBlobField |
| LONGBLOB | ftBlob | TBlobField |
| TINYTEXT | ftMemo | TMemoField |
| TEXT | ftMemo | TMemoField |
| MEDIUMTEXT | ftMemo | TMemoField |
 | Some of the string/memo fields would be mapped into widestring and widememo fields in BDS2006. |
