MySQL Data Type |
Iron Speed Designer Validation Type |
BIGINT |
Number |
BINARY |
Binary (see notes below) |
BIT |
Boolean (see notes below) |
BLOB |
Image |
BOOLEAN |
Boolean |
CHAR |
String |
DATE |
Date |
DATETIME |
Date |
DECIMAL |
Number |
DOUBLE |
Number |
ENUM |
String (see notes below) |
FLOAT |
Number |
INT |
Number |
LONGBLOB |
Image |
LONGTEXT |
Very Large String |
MEDIUMBLOB |
Image |
MEDIUMINT |
Number |
MEDIUMTEXT |
Very Large String |
REAL |
Number |
SMALLINT |
Number |
SET |
String (see notes below) |
TEXT |
Very Large String |
TIME |
Date |
TIMESTAMP |
Date |
TINYBLOB |
Image |
TINYINT |
Number |
TINYTEXT |
String |
VARBINARY |
Binary (see notes below) |
VARCHAR |
String |
YEAR |
String |
The Binary and Varbinary data types are not currently supported due to bugs in the MySQL .NET provider. Binary and Varbinary fields are being returned improperly as strings instead of as byte arrays.
We recommend using Blob fields instead.
We recommend you do not use use the list field validation types (dropdown list, list box and radio button list) for Bit fields. By default, the checkbox is used for Bit fields and will work as expected.
In the case where list is used for a Bit field permitting a NULL, a bug in the MySQL provider returns all the values as NULL, even though some may be True or False.
Certain versions of MySQL contain values for the Date data type such as ‘0000-00-00’ instead of the NULL value. This is a bug in MySQL. We recommend you to make sure that Date fields contain either all valid values or NULL values.
The ENUM data type in MySQL is a string type field that defines a list of possible values. Example: ENUM(‘A’, ‘B’, ‘C’) means that ‘A’, ‘B’, and ‘C’ are the possible valid values. Iron Speed Designer maps the ENUM data type to the String validation type and creates a column constraint for the value list such as: ‘A’, ‘B’, ‘C’. This column constraint can be seen in the Databases tab in Iron Speed Designer.
The SET datatype is a string type, but is often referred to as a complex type due to the increased complexity involved in implementing them. A SET datatype can hold any number of strings from a predefined list of strings specified during table creation. The SET datatype is similar to the ENUM datatype in that they both work with predefined sets of strings, but where the ENUM datatype restricts you to a single member of the set of predefined strings, the SET datatype allows you to store any of the values together, from none to all of them. Due to this complexity, Iron Speed Designer does not create any special constraints or validations used when adding or editing fields of type SET. It is up to the user to input correct values and validation of those inputs is done by the database server itself.