Store RTF in SQLite TEXT

RTF(Rich Text Format) can be stored as SQLite TEXT data. 1. SQLite TEXT Type Overview SQLite TEXT has no length limits (disk-bound) and is lightweight for character storage. Embedded database (no server required) with extremely simple syntax. 2. Pure SQL Implementation Steps Step 1: Create Table ... Read more

SQLite TEXT

SQLite doesn’t have a dedicated CLOB data type. However, it can handle large text data using the TEXT type. In SQLite, the TEXT data type is a fundamental and widely – used option for storing character – based data. Overview of TEXT data type in SQLite The TEXT data type in ... Read more