When used with the maximum page size of 65536 this gives a maximum SQLite database size of about 281 terabytes. The max_page_count PRAGMA can be used to raise or lower this limit at run-time. it can make some small database till the limit but you are in the need of creating large databases ig...
I will recommend you to use varchar..
maximum size of a VARCHAR in SQLite.. You can declare a VARCHAR 10 and SQLite will be happy to store a 500million character string there. And it will keep all 500million characters intact.