Android database-SQLite, supported data types

SQLite is especially convenient for storing mobile phone data, but I found some problems during usage:

Data Type:

Case Insensitive

Text Text

Numeric Value

Integer Integer

Real Decimal

None No type

The above data type is correct.

1. However, if you use other data types such as varchar to create a table, an error occurs. You cannot create a table.

2. If you have used some SQLite table creation tools to create tables, including varchar and other data types, the database can be used. This problem is very strange.

3. I am android2.0. I did a real machine test on Moto -- xt800 and found this problem.