TheDeveloperBlog.com
C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML
SQLite Data Types
SQLite Data Types with history, features, advantages, installation, commands, syntax, datatypes, operators, expressions, databases, table, crud operations, clauses, like, glob, limit, and clause, advance sqlite
SQLite Data TypesSQLite data types are used to specify type of data of any object. Each column, variable and expression has related data type in SQLite. These data types are used while creating table. SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with its container. Types of SQLite data typesSQLite Storage Classes The stored values in a SQLite database has one of the following storage classes:
Note: SQLite storage class is slightly more general than a data type. For example: The INTEGER storage class includes 6 different integer data types of different lengths.SQLite Afinity Types
SQLite supports type affinity for columns. Any column can still store any type of data but the preferred storage class for a column is called its affinity. There are following type affinity used to assign in SQLite3 database.
SQLite Affinity and Type Names
Following is a list of various data types names which can be used while creating SQLite tables.
Date and Time Data Type
In SQLite, there is no separate class to store dates and times. But you can store date and times as TEXT, REAL or INTEGER values.
Boolean Data TypeIn SQLite, there is not a separate Boolean storage class. Instead, Boolean values are stored as integers 0 (false) and 1 (true).
Next TopicSQLite Operators
|
Related Links:
- Learn SQLite Tutorial
- SQLite History
- SQLite Interview Questions (2021)
- SQLite Data Types
- SQLite Operators
- SQLite Features
- SQLite Advantages and Disadvantages
- SQLite Installation
- SQLite Commands
- SQLite Syntax
- SQLite Expressions
- SQLite Create Database
- SQLite Attach Database
- SQLite Detach Database
- SQLite Create Table
- SQLite Like Clause
- SQLite Drop Table
- SQLite Insert Query
- SQLite Select Query
- SQLite Joins
- SQLite Update Query
- SQLite Delete Query
- SQLite Where Clause
- SQLite And Clause
- SQLite OR Clause
- SQLite Glob Clause
- SQLite Limit Clause
- SQLite Order by Clause
- SQLite juliandday
- SQLite strftime
- SQLite time
- SQLite Group by Clause
- SQLite Having Clause
- SQLite Distinct Keyword
- SQLite Union
- SQLite Union All
- SQLite Inner Join
- SQLite Outer Join
- SQLite Cross Join
- SQLite Date and Time
- SQLite date
- SQLite datetime
- SQLite now
- SQLite Aggregate Functions
- SQLite MIN Function
- SQLite MAX Function
- SQLite AVG Function
- SQLite COUNT Function
- SQLite SUM Function
- SQLite Triggers
- SQLite Trigger After Insert
- SQLite Trigger After Update
- SQLite Trigger After Delete
- SQLite Drop Trigger
- SQLite Primary Key
- SQLite Foreign Key
- SQLite Import
- SQLite Export