{"id":77,"date":"2017-03-09T06:29:25","date_gmt":"2017-03-09T06:29:25","guid":{"rendered":"http:\/\/abhiandroid.com\/database\/?p=77"},"modified":"2017-03-09T06:29:45","modified_gmt":"2017-03-09T06:29:45","slug":"data-type-command-sqlite","status":"publish","type":"post","link":"https:\/\/abhiandroid.com\/database\/data-type-command-sqlite.html","title":{"rendered":"Data Type And Commands In SQLite"},"content":{"rendered":"

Data Type in SQLite:<\/strong> It basically specify the kind of data that object will store in it i.e the value it can take inside for storage. There are different type or data like numeric, alphabetic, alphanumeric etc. So to store all this type of data different data types are there. Also the data types defines the value to be stored or the operations that can be carried out over the data.<\/p>\n

SQLite database is dynamic type<\/strong> i.e the type of value to be stored in the container is decided by the value itself. In other words SQLite uses static and rigid typing i.e allows us to define data as per value.<\/p>\n

Let’s take example to understand\u00a0the point more clear:<\/p>\n

create table demo_table( Number int(15), Name varchar(50) );\r\ninsert into demo_table (Number , Name) values ('EA', '102');<\/pre>\n
Here in the above example we define datatype of Number\u00a0as Integer and Name\u00a0as Varchar. In second line we inserted character value in Number and Number in Name\u00a0using insert command. This query will run without any error because\u00a0SQLite engine allows rigid typing usually try to automatically convert values to the appropriate datatype.<\/p>\n
\n
Storage Classes<\/strong><\/h4>\n
Null :\u00a0<\/strong><\/span>The value is a NULL value.
\nInteger :\u00a0<\/span><\/strong>The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.
\nReal :\u00a0<\/span><\/strong>The value is a floating point value, stored as an 8-byte IEEE floating point number.
\nText :\u00a0<\/span><\/strong>The value is a text string, stored using the database encoding (UTF- 8, UTF-16BE or UTF-16LE)
\nBlob :\u00a0<\/span><\/strong>The value is a blob of data, stored exactly as it was input.<\/p>\n
We have\u00a0used above classes in commands of this article.<\/p>\n
\n
SQLite Affinity Type:<\/strong><\/h4>\n
In order to maximize compatibility between SQLite and other database engines, SQLite supports the concept of “type affinity” on columns. Type affinity is the recommended type for data stored in that column. Any column can store any type of data. The preferred storage class for a column is called its “affinity”.<\/p>\n
Each column has assigned following type affinities:<\/p>\n