The following data types are supported in Hyperstage. Note that numeric data types ranges are 1 less than the MySQL minimums and maximums.
Numeric Types | ||
---|---|---|
Data Type |
Minimum |
Maximum |
TINYINT |
-127 |
127 |
BOOL, BOOLEAN |
-127 |
127 |
SMALLINT |
-32767 |
32767 |
MEDIUMINT |
-8388608 |
8388608 |
INT (INTEGER) |
-2147483647 |
2147483647 |
BIGINT |
-9223372036854775807 |
-9223372036854775807 |
FLOAT |
-3.402823466E+38 |
3.402823466E+38 |
DOUBLE (DOUBLE PRECISION) |
-1.7976931348623157E+308 |
1.7976931348623157E+308 |
DEC(M, D)
(DECIMAL(M, D))
where: 0 < M <= 18 and 0 <= D <= M |
-(1E+M - 1) / (1E+D) |
(1E+M - 1) / (1E+D) |
Date and Time Types | |||
---|---|---|---|
Data Type |
Minimum |
Maximum |
Format |
DATE |
100-01-01 |
9999-12-31 |
YYYY-mm-dd |
DATETIME |
100-01-01 00:00:00 |
9999-12-31 23:59:59 |
YYYY-mm-dd HH:MM:SS |
TIMESTAMP |
1970-01-01 00:00:00 |
2038-01-01 00:59:59 |
YYYY-mm-dd HH:MM:SS |
TIME |
-838:59:59 |
838:59:59 |
HHH:MM:SS |
YEAR (4-digit format only) |
1901 |
2155 |
YYYY |
String Type | |
---|---|
Data Type |
Maximum Length |
CHAR(N) |
255 |
VARCHAR(N) |
65532 |
BINARY(N) |
255 |
VARBINARY(N) |
65532 |
TINYTEXT |
255 |
TEXT(N) |
65535 |
WebFOCUS |