Sqlite3 import without delimiters

Question

I have problem opposite to usual one: Need to import file into sqlite table and I don't need any delimiters, just one line into one column. Is it possible to do with command line or I need to write my custom program?

Answer 1

It is possible with command line. If it is TEXT data, the trick will be picking a separator that never appears in the text.

Maybe there's no such thing as 100%, but perhaps .separator "\a" (bell) or .separator "\b" (backspace) would be safe bets. Of course I don't know the data......