>> > In fts tables all columns other than rowid are of type TEXT. It
>> > doesn't matter what you put in the type, they will be of type TEXT.
>> > The rowid is the standard SQLite rowid, so it does provide an INTEGER
>> > PRIMARY KEY AUTOINCREMENT column.
>> Scott, thanks for your reply. Howeve
Adam,
As it currently stands, fts2 (and fts1, if you ever do a delete) is
broken if you use VACUUM. It's not an issue of how the table is
defined, it's an issue of the internal definitions - when fixed, it
will just be fixed, you won't define your tables differently.
[There's been some discussio
"Scott Hess" <[EMAIL PROTECTED]> writes:
> In fts tables all columns other than rowid are of type TEXT. It
> doesn't matter what you put in the type, they will be of type TEXT.
> The rowid is the standard SQLite rowid, so it does provide an INTEGER
> PRIMARY KEY AUTOINCREMENT column.
Scott, than
3 matches
Mail list logo
