I’m using integer for most of my numeric data, and this is fine, but the
system I am building will convert my data structures OLTP to OLAP for
reporting. This will require TONS of data to be saved. In an effort to
reduce wasted space I’d rather use tinyint/smallint and other such more
precise data types in mysql.
Couldn’t find any documentation about these ‘nonstandard’ data types. In
addition I couldn’t find anything on use column options like “unsigned”.