Data types

byte – 1-byte signed integer numbers. The range of numbers is from -128 to 127.

short – 2-byte signed integer numbers. The range of numbers is from -32768 to 32767.

integer – 4-byte signed integer numbers. The range of numbers is from -2147483648 to 2147483647.

long – 8-byte signed integer numbers. The range of numbers is from -9223372036854775808 to 9223372036854775807.

float – 4-byte single-precision floating point numbers.

double – 8-byte double-precision floating point numbers.

decimal – Signed decimal numbers with up to 38 digits total and 18 digits after the decimal point.

string – Character string values.

boolean – Boolean type has one of two possible values: `true` and `false` or `yes` and `no`.

timestamp – Values comprising fields year, month, day, hour, minute, and second.

date – Values comprising fields year, month and day.