Data Types¶
MemSQL supports the following data types:
Integer Numbers¶
BOOL, BOOLEAN
TINYINT
SMALLINT
INT, INTEGER
MEDIUMINT
BIGINT
Real Numbers¶
DOUBLE
DEC, FIXED, DECIMAL
NUMERIC
NEWDECIMAL
Time and Date¶
DATE
TIME
TIMESTAMP
DATETIME
YEAR
String Types¶
CHAR(LENGTH)
VARCHAR
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT
BINARY(LENGTH)
VARBINARY
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB
ENUM
SET
Note
MemSQL requires that CHAR and BINARY be specified with a length. Values of type CHAR require 4 x LENGTH bytes of memory, as MemSQL only supports the utf8 charset (for more info see String Encoding and Collations). Values of type BINARY require LENGTH bytes of memory.