Validating data types any new online dating site 2016
If you assign a value to a CHARACTER column containing fewer characters than the defined length, the remaining space is filled with blanks characters.
Data types define what type of data a column can contain.
The scale for a DECIMAL cannot be larger than the precision.
DECIMAL data types can be declared in one of three different ways.
Attempting to assign values outside this range causes an error.
If you assign a numeric value with a precision and scale to a SMALLINT data type, the scale portion truncates, without rounding.