SqlLite with Full text support

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
JvanDorsten
Posts: 10
Joined: Tue 03 Jan 2006 15:59

SqlLite with Full text support

Post by JvanDorsten » Thu 17 Apr 2008 15:02

Hello,

I have downloaded the trial for sqLite, we are currently finding out is SqLite is suitable for our needs.

We need Full text support wich is included in FTS2.dll according to de SqLite website, or it should be compiled in sqlite2.dll

I searched the internet but could not find an compiled dll or way to get full text support in SqLite.

Can you provide an dll with this support, or explain how to get Full text support in SqlLite, and if it works with CodeLab?

Kind regards,
Jon van Dorsten

JvanDorsten
Posts: 10
Joined: Tue 03 Jan 2006 15:59

Post by JvanDorsten » Fri 18 Apr 2008 07:08

Meanwhile i discovered that the fts included in the installer is fts3, so i had to create an virtual table with fts3 in the statement.

It works now.

Alexey.mdr
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Post by Alexey.mdr » Fri 18 Apr 2008 15:17

Full text search is enabled in sqlite3.dll with fts3.dll,
and you can use this feature with dotConnect for SQLite.

Post Reply