Data Type of the Target Column and Inserted Value

Assume that C is a target column and v a value that is not equal to the NULL value.

v is to be inserted in C by means of an INSERT statement.
v is to be used to modify C with an UPDATE statement.

Target column C

Required value for v

Numeric column

Number within the permissible range of C.

INSERT statement: if v is the result of a QUERY expression, decimal places are rounded off if necessary.

UPDATE statement: if v is the result of an expression that does not comprise one single numeric literal, decimal places are rounded off if necessary.

Alphanumeric column with the code attribute ASCII, UNICODE

Character string whose length is not greater than the length attribute of C. Subsequent blanks are ignored when the length of v is calculated. If the length of v is shorter than the length attribute of C, then v is lengthened by the corresponding number of blanks.

Alphanumeric column with the code attribute BYTE

Hexadecimal character string whose length is not greater than the length attribute of C. Subsequent binary zeros are ignored when the length of v is calculated. If the length of v is shorter than the length attribute of C, then v is lengthened by the corresponding number of binary zeros.

Data type DATE

Date value in the current date format.

Data type TIME

Time value in the current time format.

Data type TIMESTAMP

Timestamp value in the current timestamp format.

Data type BOOLEAN

One of the values TRUE or FALSE (BOOLEAN)