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 |