Re: [sqlite] Possible bug in FTS3 or Parametrization?

2011-08-05 Thread Martin Gill
On 5 August 2011 14:55, Dan Kennedy wrote: > On 08/05/2011 05:44 PM, Martin Gill wrote: >> On 5 August 2011 10:55, Dan Kennedy  wrote: >>> >>> On 08/05/2011 02:58 PM, Martin Gill wrote: >>>> >>              SQLiteParameter param1 = command.Cr

Re: [sqlite] Possible bug in FTS3 or Parametrization?

2011-08-05 Thread Martin Gill
On 5 August 2011 10:55, Dan Kennedy wrote: > > On 08/05/2011 02:58 PM, Martin Gill wrote: > > > > CREATE VIRTUAL TABLE full_text USING FTS3 (id,text) > > INSERT INTO full_text VALUES ('1', 'I have a foréign character.') > > SQLite does not

[sqlite] Possible bug in FTS3 or Parametrization?

2011-08-05 Thread Martin Gill
Hi all I have discovered what may be a bug in either SQLLite or System.Data.SQLite (v 1.0.66.0 using SQLite 3.6.23.1). I certainly don't understand what's happening and I'd apprecite it if someone could help me out; perhaps I'm missing something. To recreate the issue create a database with the f