Lecture 25/10/16 - Database datatypes

Numeric

INT  Whole numbers
FLOAT  Approx real numbers
DECIMAL  Exact storage of real numbers

Date

DATE  TIME  DATETIME

Strings

VARCHAR  CHAR  TEXT  ENUM  BLOB

The length can be set for CHAR/VARCHAR types. ENUM for fixed selection. TEXT for longer chunks of text.


Revision #1
Created Mon, Apr 24, 2017 10:21 PM by Christopher Wilkinson
Updated Mon, Apr 24, 2017 10:25 PM by Christopher Wilkinson