Chapter 3

1. CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, SET.
2. They make your database size much larger and hurt query performance.
3. INT, FLOAT, DOUBLE, DECIMAL, BIT.
4. Use this when you are concerned about the upper bounds of the range on your INT.
5. DATE, TIME, DATETIME, TIMESTAMP, YEAR.
6. Oracle, PostgreSQL, and SQL Server.
7. JSON and spatial data types.
8. You want to pick the smallest data type that will hold your data so that you can have the fastest query performance.
9. TINYINT.
10. VARCHAR.