The TINYINT data type is an exact numeric data type; its accuracy is preserved after arithmetic operations.
The range for TINYINT values is 0 to 28 - 1, or 0 to 255.
In embedded SQL, TINYINT columns should not be fetched into variables defined as CHAR, since the result is an attempt to convert
the value of the column to a string and then assign the first byte to the variable in the program. Instead, TINYINT columns
should be fetched into 2-byte or 4-byte integer columns. To send a TINYINT value to a database from an application written
in C, the type of the C variable should be INTEGER.
When converting a string to a TINYINT, leading and trailing spaces are removed. If the leading character is +, it is ignored.
If the leading character is -, the remaining digits are interpreted as a negative number. Leading 0 characters are skipped,
and the remaining characters are converted to an integer value. An error is returned if the value is out of the valid range
for the destination data type, if the string contains illegal characters, or if the string cannot be decoded as an integer
value.
Syntax