In MySQL there are three main data types:
- Numeric
- String
- Date and time.
SteamPipes is using the version 8.0.3 via Docker
| Support | Name | Storage Size | Range | StreamPipes Domain |
|---|
| No | tinyint signed | 1 bytes | -128 to 127 | |
| No | smallint signed | 2 bytes | -32768 to +32767 | |
| No | mediumint | 3 bytes | -8388608 to 8388607 | |
| No | int or integer unsigned | 4 bytes | 0 to 4294967295 | |
| Yes | int or integer signed | 4 bytes | -2147483648 to +2147483647 | http://www.w3.org/2001/XMLSchema#integer |
| No | bigint unsigned | 8 bytes | 0 to 18446744073709551615 | |
| Yes | bigint signed | 8 bytes | -9223372036854775808 to +9223372036854775807 | http://www.w3.org/2001/XMLSchema#long |
- (size ,D): An exact fixed-point number. The total number of digits is specified in size. The number of digits after the decimal point is specified in the d parameter. The maximum number for size is 65. The maximum number for d is 30. The default value for size is 10. The default value for d is 0.
- (p): A floating point number. MySQL uses the p value to determine whether to use FLOAT or DOUBLE for the resulting data type. If p is from 0 to 24, the data type becomes FLOAT(). If p is from 25 to 53, the data type becomes DOUBLE()
MySQL does not have built-in Boolean type. However, it uses TINYINT(1) instead.
| Recognized | True | False |
|---|
| Yes | true | false |
| ? | TRUE | FALSE |
| ? | True | False |
| ? | 1 | 0 |
A bit-value type. The number of bits per value is specified in size. The size parameter can hold a value from 1 to 64. The default value for size is 1.
| Supported | Name | Storage Size | Range | StreamPipes Domain |
|---|
| ? | bit(size) | | | |
- The size parameter can hold a value from 1 to 64.
| Supported | Data type | Description | StreamPipes Domain |
|---|
| ? | CHAR(size) | A FIXED length string (can contain letters, numbers, and special characters). The size parameter specifies the column length in characters - can be from 0 to 255. Default is 1 | |
| Yes | VARCHAR(size) | A VARIABLE length string (can contain letters, numbers, and special characters). The size parameter specifies the maximum column length in characters - can be from 0 to 65535 | http://www.w3.org/2001/XMLSchema#string with size 255 |
| ? | BINARY(size) | Equal to CHAR(), but stores binary byte strings. The size parameter specifies the column length in bytes. Default is 1 | |
| No | VARBINARY(size) | Equal to VARCHAR(), but stores binary byte strings. The size parameter specifies the maximum column length in bytes. | |
| No | TINYBLOB | For BLOBs (Binary Large OBjects). Max length: 255 bytes | |
| No | TINYTEXT | Holds a string with a maximum length of 255 characters | |
| ? | TEXT(size) | Holds a string with a maximum length of 65,535 bytes | |
| ? | BLOB(size) | For BLOBs (Binary Large OBjects). Holds up to 65,535 bytes of data | |
| No | MEDIUMTEXT | Holds a string with a maximum length of 16,777,215 characters | |
| No | MEDIUMBLOB | For BLOBs (Binary Large Objects). Holds up to 16,777,215 bytes of data | |
| ? | LONGTEXT | Holds a string with a maximum length of 4,294,967,295 characters | |
| No | LONGBLOB | For BLOBs (Binary Large OBjects). Holds up to 4,294,967,295 bytes of data | |
| No | ENUM(val1, val2, val3, ...) | A string object that can have only one value, chosen from a list of possible values. You can list up to 65535 values in an ENUM list. If a value is inserted that is not in the list, a blank value will be inserted. The values are sorted in the order you enter them | |
| No | SET(val1, val2, val3, ...) | A string object that can have 0 or more values, chosen from a list of possible values. You can list up to 64 values in a SET list | |
| Supported | Name | Description | StreamPipes Domain |
|---|
| ? | DATE | A date. Format: YYYY-MM-DD. The supported range is from '1000-01-01' to '9999-12-31' | |
| Yes | DATETIME(fsp) | A date and time combination. Format: YYYY-MM-DD hh:mm:ss. The supported range is from '1000-01-01 00:00:00' to '9999-12-31 23:59:59'. Adding DEFAULT and ON UPDATE in the column definition to get automatic initialization and updating to the current date and time | SO.DateTime <br> http://schema.org/DateTime |
| ? | TIMESTAMP(fsp) | A timestamp. TIMESTAMP values are stored as the number of seconds since the Unix epoch ('1970-01-01 00:00:00' UTC). Format: YYYY-MM-DD hh:mm:ss. The supported range is from '1970-01-01 00:00:01' UTC to '2038-01-09 03:14:07' UTC. Automatic initialization and updating to the current date and time can be specified using DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP in the column definition | |
| ? | TIME(fsp) | A time. Format: hh:mm:ss. The supported range is from '-838:59:59' to '838:59:59' | |
| ? | YEAR | A year in four-digit format. Values allowed in four-digit format: 1901 to 2155, and 0000. | |