SQLite function to specify exactly how the data is stored internally
The storage size has no effect at the SQL language level, so there is no SQL function to determine it.

However, the record format is documented; SQLite always uses the smallest serial type into which the value fits.