Topic: To convert the table with FTS from MSSQL in SQLITE
In MSSQL is available table1 c fields
Across the field mytext it is installed FTS.
It is necessary to copy the table in sqlite.
At creation fts tables in sqlte with the help
CREATE VIRTUAL TABLE table1 USING fts4 (mytext);
However, it was clarified that in fts to the table it is impossible to create type fields datetime or int.
As in sqlite to create corresponding table1 the table with fts
In sqlite to write request
select publishDate, mytext from table1 where Contains (mytext, ' searchstr ') and (publishDate> d1) and (publishDate <d2)