NOTE

MySQL Data Types

Choosing numeric, temporal, string, binary, JSON, and exact-value types from semantics and access patterns.

DatabasesCreated 05/09/2021Updated 09/15/20261 min readhistorical

This is a historical learning note and may contain outdated or incomplete understanding.

Choose a MySQL data type from the domain’s semantics first: range and signedness for integers, DECIMAL for exact decimal values such as money when appropriate, temporal types for time semantics, and bounded character/binary types for textual or opaque data.

Type choice affects storage, comparison, indexing, collation, implicit conversions, and application compatibility. Avoid storing structured numeric/time values as strings merely for convenience.