I'm experimenting with the FTS capability and have a question....
How do I enter a value in the database that is hyphenated? Seems to be
backwards form what I would expect....if the content contains a hyphen then
only non-hyphenated query returns the correct value whereas the hyphenated one
returns the wrong one.
This seems to not work correctly...or am I missing a concept here?
SQLite version 3.7.2
sqlite> create virtual table dict using fts3(content);
sqlite> insert into dict values('play-off');
sqlite> insert into dict values('play-back');
sqlite> select * from dict where content match 'play-back';
play-off
sqlite> select * from dict where content match 'play-off';
play-back
sqlite> select * from dict where content match 'play off';
play-off
sqlite> select * from dict where content match 'play back';
play-back
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Northrop Grumman Information Systems
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
