INTEGER: An integer is a whole number without a decimal point.
REAL: A real number is a number with a decimal point.
TEXT: A text is a string of characters.
BLOB: A BLOB is a binary large object, which can be any type of data, such as a file, an image, or a video.
SQLite also supports a number of other data types, such as:
DATE: A date is a specific day and time.
TIME: A time is a specific hour, minute, and second.
DATETIME: A datetime is a combination of a date and a time.
NUMERIC: A numeric is a number that can be either an integer or a real number.
VARCHAR: A varchar is a variable-length string of characters.
CHAR: A char is a fixed-length string of characters.
SQLite is a powerful database that can be used to store a wide variety of data. By using the appropriate data type for your data, you can ensure that your data is stored efficiently and accurately.
We use cookies to ensure you have the best browsing experience on our website. By using our site, you
acknowledge that you have read and understood our
Cookie Policy &
Privacy Policy.
SQLite supports the following data types:
SQLite also supports a number of other data types, such as:
SQLite is a powerful database that can be used to store a wide variety of data. By using the appropriate data type for your data, you can ensure that your data is stored efficiently and accurately.