A null can be assigned to a column of any data type if the column was defined as a nullable column. A null can also be assigned to a host language variable if there is an indicator variable associated with the host variable.

To ensure that a null is not assigned to a column, use the IFNULL function (see page Null Handling Functions).