[sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

2017-03-12 Thread andrea-...@libero.it
Thanks for replay. I've tried now with SQLite Command Line Shell, 82 rows as expected (like DB Browser for SQLite). Same query in VB,net 124 rows (???) >Messaggio originale >Da: "Simon Slavin" >Data: 12/03/2017 20.36 >A: "SQLite mailing list" >Ogg: Re: [sqlite] Result error in Sys

Re: [sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

2017-03-12 Thread Simon Slavin
On 13 Mar 2017, at 5:04am, andrea-...@libero.it wrote: > > I've tried now with SQLite Command Line Shell, 82 rows as expected (like DB > Browser for SQLite). > Same query in VB,net 124 rows (???) This throws strong suspicion on where the problem lies. The SQLite command line shell tool is wri

Re: [sqlite] R: Re: Result error in System.Data.SQlite COLLATE NOCASE

2017-03-12 Thread Simon Slavin
On 13 Mar 2017, at 5:11am, Simon Slavin wrote: > The SQLite command line shell tool is written and maintained by the SQLite > developer team. If there’s a but in it they’ll fix it. However, DB Browser > for SQLite is not and faults in it should be reported to whoever > wrote/supports it. Th