[sqlite] non-integer rowid/document id

Excerpts from jeremy's message of 2015-12-14 11:09:48 -0700: > Hi all, > > I'm working with FTS5 and I'd like to guarantee that a particular document is > indexed only once. I have what I consider to be a document id, but it is not > an > integer value its a hexadecimal string, think

[sqlite] non-integer rowid/document id

Hi all, I'm working with FTS5 and I'd like to guarantee that a particular document is indexed only once. I have what I consider to be a document id, but it is not an integer value its a hexadecimal string, think GUID/md5/sha1. Since the fts5 rowid column is an integer, it appears I'll need to