can i ask, if specifying a type as an integer, will all integer values embedded within the column associated with this type, be of the same byte size? or are do they equate to 1 byte per actual number character?
i.e. 1 = 1 byte, 123, 3 bytes & so forth.
its just that im designing columns to contain boolean-type values, & am [far too obsessed when] concerning physical storage space efficiency.
"CHECK (isAbstract IN ('Yes','No'))" - you know that only 'Yes' and 'No' are valid values? 'yes' and 'no' will be invalid, just like 'YES' and 'NO' and other combinations. Do you really want to keep that in mind? Will you, for example, user something like
... WHERE initcap(some_column) = 'Yes' or
... WHERE upper(some_column) = upper('Yes') etc.
Not that this is wrong or impossible, but - perhaps - 0 and 1 are simpler.