Datatypes In SQLite Version 3:

Note that a declared type of "FLOATING POINT" would give INTEGER affinity, not REAL affinity, due to the "INT" at the end of "POINT".


Oh, well, sure. Wait... what?