Data type | Description |
String ("VARCHAR") | A sequence of Unicode characters. You can specify a maximum character length for the string. For example, VARCHAR (30) represents strings with a maximum length of 30 Unicode characters. |
Integer number ("INTEGER") | 32-bit two’s-complement arithmetic numbers. |
Decimal number ("DECIMAL") | Fixed point numbers consisting of up to 100 digits. You can specify a maximum scale and a maximum precision using the syntax (precision, scale). For example, DECIMAL (15, 4) represents decimals that can have up to 15 digits in all and up to 4 digits after the decimal point. |
Floating point number ("DOUBLE") | 64-bit IEEE double precision floating point numbers. |
Timestamp ("TIMESTAMP") | A combined date and time (hour/minute/second). |