Database Field Support in MySQL

MySQL Data Type	Iron Speed Designer Validation Type
BIGINT BIGINT UNSIGNED	Number
BINARY	Binary (see notes below)
BIT	Boolean (see notes below)
BLOB	Image
BOOLEAN	Boolean
CHAR	String
DATE	Date
DATETIME	Date
DECIMAL DECIMAL UNSIGNED	Number
DOUBLE DOUBLE UNSIGNED	Number
ENUM	String (see notes below)
FLOAT FLOAT UNSIGNED	Number
INT INT UNSIGNED	Number
LONGBLOB	Image
LONGTEXT	Very Large String
MEDIUMBLOB	Image
MEDIUMINT MEDIUMINT UNSIGNED	Number
MEDIUMTEXT	Very Large String
REAL REAL UNSIGNED	Number
SMALLINT SMALLINT UNSIGNED	Number
SET	String (see notes below)
TEXT	Very Large String
TIME	Date
TIMESTAMP	Date
TINYBLOB	Image
TINYINT TINYINT UNSIGNED	Number
TINYTEXT	String
VARBINARY	Binary (see notes below)
VARCHAR	String
YEAR	String

Binary and varbinary data types

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.

Bit data type

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.

Date data type

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.

Enum data type

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.

Set data type

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.