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.CreateParameter(); >>              param1.Value = "FORÉIGN

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

2011-08-05 Thread Dan Kennedy
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: >>> >>> CREATE VIRTUAL TABLE full_text USING FTS3 (id,text) >>> INSERT INTO full_text VALUES ('1', 'I have a foréign character.') >> >> SQLite does not recognize

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 recognize upper/lower-case mappings for non-ASCII > charac

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

2011-08-05 Thread Dan Kennedy
On 08/05/2011 02:58 PM, Martin Gill wrote: > 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 somethin