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 |
Any other data types are not supported.