Data Types

Supported Data Types

Data Types supported by Xpand include:

• BIGINT
• BINARY
• BIT
• BLOB 
• BOOL 
• CHAR 
• DATE and DATETIME including Fractional Seconds
• DECIMAL (M,D) 
• DOUBLE (M,D) 
• DOUBLE PRECISION (M,D) (is treated as DOUBLE) 
• ENUM ("A") 
• FLOAT (M,D) 
• INT 
• JSON 

• LONGBLOB

• LONGTEXT      

• MEDIUMBLOB 
• MEDIUMINT 
• MEDIUMTEXT 
• NUMERIC (M,D) (is treated as DECIMAL) 
• REAL (is treated as DOUBLE) 
• SERIAL (is treated as BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT) 
• SET ("A","B") SMALLINT TEXT TIME TIMESTAMP
• SMALLINT
• TEXT
• TIME
• TINYBLOB 
• TINYINT 
• TINYTEXT 
• VARBINARY 
• VARCHAR 
• YEAR 

Unsupported Data Types

Xpand does not support:

• Spatial Extensions

Caveats for Data Type Support

• Boolean values (True, False, Null) are accepted in a DATETIME column. This matches the behavior for MySQL v5.5. MySQL v5.6 provides an error message. 
• On Xpand, supplying a zero value for day, month, or year within a date will in a zero date ('0000-00-00'). MySQL will issue an error (if the sql_mode for NO_ZERO_IN_DATE) is set, or allow zero value for the specific portion of the date. 
• Xpand permits table definitions that use the VARCHAR data type with no max length, and supply a default max length of 21845. MySQL does not permit this. 
• When creating a column of type bit(0), MySQL will automatically create a bit(1). Xpand will not allow you to create a column with type bit(0) and will provide an error message.