Datatypes In SQLite Version 3

NULL. The value is a NULL value.

INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.

REAL. The value is a floating point value, stored as an 8-byte IEEE floating point number.

TEXT. The value is a text string, stored using the database encoding (UTF-8, UTF-16BE or UTF-16LE).

BLOB. The value is a blob of data, stored exactly as it was input.

JAVA
Short.MAX_VALUE: 32767 -> 約3万
Short.MIN_VALUE: -32768
Integer.MAX_VALUE: 2147483647 -> 約21億
Integer.MIN_VALUE: -2147483648
Long.MAX_VALUE: 9223372036854775807 -> 約922京(けい)
Long.MIN_VALUE: -9223372036854775808
Float.MAX_VALUE: 3.4028235E38 -> 約340澗(かん)
Float.MIN_VALUE: 1.4E-45
Double.MAX_VALUE: 1.7976931348623157E308 -> 約1.7澗(かん) x 1無量大数 x 1無量大数 x 1無量大数 x 1無量大数
Double.MIN_VALUE: 4.9E-324