SQL Pt 2: Data Types

Intro

String Data Types

CHAR (byte size) — Character Data Type

VARCHAR (byte size) — Variable Character Data Type

NVARCHAR (byte size) — Variable Character Data Type for UNICODE

ENUM (pre-set val-1, pre-set val-2, … pre-set val-n) — Enumerate Data Type

Integer Data Types

TINYINT

SMALLINT

MEDIUMINT

INT

BIGINT

Fixed and Floating-point Data Types

DECIMAL (precision, scale) or NUMERIC (precision, scale)

FLOAT (precision, scale) and DOUBLE (precision, scale)

FLOAT:

DOUBLE :

Time Data Types

Special Mention: BLOB

Just another one of those dreamers with a sparkle in his eyes.