SQLite Learning Day No. 02: Data Types

Reference: http://www.w3cschool.cc/sqlite/sqlite-data-types.html

In SQLite, the concept of data type looks very vague, the beginning of contact feeling and C language provides the concept of data type is far away, do not know whether this is the function of the weakening or flexibility of the improvement, can only and experience it.

The concept of storage classes and affinity types is presented in the Data Types section, with regard to storage classes similar to the regular C language data types.

And for the concept of the affinity type, my understanding is that SQLite has a fine classification of storage types, and these types can find the most similar storage class, and this similar storage class is this type of affinity.

This is only my personal understanding, to know the specific reason, still need to see how these types are actually operated.