mySQL Data Types

There are quite a few different data types that can be used with mySQL databases. Selecting the most appropriate data type for each field will ensure that the data is stored in the most efficient manner and can also be accessed efficiently.

We'll consider the various data types in groups since where it isn't obvious which exact data type to choose you will most likely be considering those in a small group.

Integer Data Types

Decimal Data Types

Floating Point Data Types

String Data Types

Note that the char data types are stored within the table while text data types are stored separately and referenced from the table.

Binary Data Types

Note that the binary data types are stored within the table while blob data types are stored separately and referenced from the table.

Date Data Types

Miscellaneous

 

This article written by Stephen Chapman, Felgall Pty Ltd.

go to top

FaceBook Follow
Twitter Follow
Donate