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" <slav...@bigfraud.org> >Data: 12/03/2017 20.36 >A: "SQLite mailing list"<sqlite-users@mailinglists.sqlite.org> >Ogg: Re: [sqlite] Result error in System.Data.SQlite COLLATE NOCASE > > >On 12 Mar 2017, at 7:21pm, andrea-...@libero.it wrote: > >> I've a simple select statement that have expected result in DB Browser for SQLite (82 rows).Same statement return an error in VB.NET using System.Data. SQLite (164 rows) > >Please try the same SELECT command using the SQLite Command Line Shell: > ><https://www.sqlite.org/cli.html> > >downloadable as part of the 'Precompiled Binaries' for your platform: > >https://www.sqlite.org/download.html > >Simon. >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users