Hi,
I am not sure if i understand your question right. Perhaps the following
will help:
The behaviour depends on the comparison operator.
If you do
select ...
from FileTable
where FileName = "testfile.txt"
then the whole string will be matched
If you do
select ...
from FileTable
where FileName like "%/testfile.txt"
then you would get all files named "testfile.txt" regardless of their
path. sqlite will search for strings ending in "/testfile.txt".
Martin
Ritesh Kapoor schrieb:
Hi,
I am debugging a program which has a FileTable field called FileName
declared as-
"FileName varchar(1024) primary key"
It stores filenames including their paths e.g. - "myDir1/testfile.txt"
If I were to search in this FileTable in the column FileName for a
string "testfile.txt" would it return me the row "myDir1/testfile.txt"?
I'm not sure about this but currently I think this is what is
happening. Is this the default behavior of SQLite?
Are there any setting which would make it match the whole string? So
that I don't have ambigious situations where two rows might match to the
same search string.
Thanks & Regards,
ritesh
