34
Data Types in SQL
•
Characters:
–
CHAR(20)
-- fixed length
–
VARCHAR(40)
-- variable length
•
Numbers:
–
BIGINT, INT, SMALLINT, TINYINT
–
REAL, FLOAT
-- differ in precision
–
MONEY
•
Times and dates:
–
DATE
–
DATETIME
-- SQL Server
•
Others...
All are simple