An important proviso on the strict tables is that they will not be observed on older SQLite versions lacking this feature. SQLite has been rock-solid since att

An important proviso on the strict tables is that they will not be observed on older SQLite versions lacking this feature. SQLite has been rock-solid since attaining DO-178B, and commonly isn't ever upgraded in many installations. CentOS 7 is using 3.7.17. Since the v3 database format is standardized, the older version can utilize a STRICT database file, but will not have the capability to alter datatype behavior. For these cases, implementing both STRICT and the relevant CHECK constraints is advisable.