MySQL Data Types

When you are setting up a connection to an external data source, Spotfire needs to map the data types in the data source to data types in Spotfire. See below for a list of the different data types that Spotfire supports and the applied data type mappings when working with a MySQL database.

MySQL Data Type	Spotfire Data Type
BINARY	Binary
BLOB	Binary
LONGBLOB	Binary
MEDIUMBLOB	Binary
TINYBLOB	Binary
BIT	Boolean
DATE	Date
DATETIME	DateTime
TIMESTAMP	DateTime
INT	Integer
MEDIUMINT	Integer
SMALLINT	Integer
TINYINT	Integer
YEAR	Integer
BIGINT	LongInteger
DOUBLE	Real
FLOAT	SingleReal
CHAR	String
ENUM	String
LONGTEXT	String
MEDIUMTEXT	String
NCHAR	String
NVARCHAR	String
SET	String
TINYTEXT	String
VARBINARY	String
VARCHAR	String
TIME	Time
DECIMAL(p, s)	When p <= 9 and s = 0: Integer When 9 < p <= 18 and s = 0: LongInteger Else: Real

Any other data types are not supported.