Common SQL data types

Numeric type	Int	Integer data from 231 to-231-1, storage size 2 bytes
	Smalllint	Integer data from 32768 to 32767, storage size 4 bytes
	TINYINT	0~255 integer type, storage size 1 bits
	DECIMAL ([, Q])	Decimal number, total P-bit, Q-bit after decimal point
	FLOAT	Double word floating point number
Character type data	CHAR (N)	length n Fixed length string
	VARCHAR (N)	Variable-length string with a maximum length of n
Special data types	GRAPHIC (N)	Fixed-length graph data with n lengths
	Vargraphic (N)	Variable-length graph data with maximum lengths of n
Date Time	DATE	Date type, format: YYYY-MM-DD
	Time	Time type, format: HH-MM-SS
	Datetime	Date and time

Common SQL data types