Character datatypes (CHAR, VARCHAR, TEXT) can be converted to any other datatype. Conversely, every datatype can be converted to character data. You must verify that the character string is able to be converted to the target datatype.
For example, the character string “450” can be converted to a numeric datatype such as INTEGER or DECIMAL, but the character string “Hello” causes a value error going to a numeric datatype.
