What data types does SQLite support?

What types of data Cannot be stored in SQLite?

Relevant quote: SQLite does not have a storage class set aside for storing dates and/or times.INTEGER - Stores Integer values.TEXT - Stores String Values.REAL - Stores Floating-Point Values.NULL - Empty Value.BLOB - Binary Large Object stores Files, Images, Video, or other large Objects.What types of data can SQLite databases store? - SQL FAQ

Does SQLite use varchar?

You can declare a VARCHAR(10) and SQLite will be happy to store a 500-million character string there. And it will keep all 500-million characters intact. Your content is never truncated. SQLite understands the column type of "VARCHAR(N)" to be the same as "TEXT", regardless of the value of N.

What is SQLite suitable for?

SQLite is often used as the on-disk file format for desktop applications such as version control systems, financial analysis tools, media cataloging and editing suites, CAD packages, record keeping programs, and so forth. The traditional File/Open operation calls sqlite3_open() to attach to the database file.