In this post we will talk about SQLite data type. How much typed data is in the SQLite? It has different types. As (Integer,Text,Blob,Real,Numbric) each type has its own work. In some we can save only tax. In any we can place the image. In this only we will find five types of types. Which is shown in the picture below.

SQLite Column Types For Database

1.Column Integer

We use integers for various tasks. Like 1, 2, 3, etc., just like all your numbers, so are integers. And we will know what integers are made up of. It counting quantizing numbers such as 123. These are quantizing numbers. And 0 also comes in it. There are also negatives like 5- or -9 etc. This means all numbers that counting positive, negative.

2.Column Text

Text data types in SQLite are used to store variable-length character strings. As can hold 1 GB of data. It can store data like whole sentences and paragraphs.

3.Column Blob

Blob datatypes in SQLite (binary large objects) are strings of length one by one. In SQLite, when you want to store an image, it takes the data type blob. That means you can easily store the image.

 
Top