Re: [sqlite] False Error 'no such collation sequence'

2013-06-22 Thread Tom Holden
> Date: Fri, 21 Jun 2013 21:23:20 +0300 > From: Bogdan Ureche <bogdan...@gmail.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Subject: Re: [sqlite] False Error 'no such collation sequence' > > You are mistaken. The free version of S

Re: [sqlite] False Error 'no such collation sequence'

2013-06-21 Thread Bogdan Ureche
> > I wonder, though, if there may still remain a problem for other shells > (SQLite managers?) that do not support loadable extensions, e.g., free > versions of SQLite Expert, SQLite Developer, ... You are mistaken. The free version of SQLite Expert supports loadable extensions. Bogdan Ureche

Re: [sqlite] False Error 'no such collation sequence'

2013-06-21 Thread Tom Holden
Richard Hipp drh at sqlite.org Fri Jun 21 00:15:56 EDT 2013 wrote: Can you not compile your custom collation sequences into a loadable extension (a DLL or shared library), then load that extension into your SQLite shell? http://www.sqlite.org/loadext.html - Tom replies: With Ralf's

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Ralf Junker
On 21.06.2013 05:10, Tom Holden wrote: > Ralf Junker ralfjunker at gmx.de Thu Jun 20 18:44:15 EDT 2013 wrote: > > On 19.06.2013 17:18, Tom Holden wrote: > >> I use the SQLiteSpy compilation of SQLite3 which recently upgraded >> from pre SQLite 3.7.8 to pre 4.2.0. > > You must be mistaken. As

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Richard Hipp
On Thu, Jun 20, 2013 at 11:10 PM, Tom Holden wrote: > I realise that my usage of SQLite on a database outside of the application > that created it with a proprietary collation sequence that is unavailable > to my SQLIte manager is uncommon but surely not unique. > Can you not

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Tom Holden
Ralf Junker ralfjunker at gmx.de Thu Jun 20 18:44:15 EDT 2013 wrote: On 19.06.2013 17:18, Tom Holden wrote: I use the SQLiteSpy compilation of SQLite3 which recently upgraded from pre SQLite 3.7.8 to pre 4.2.0. You must be mistaken. As the author of SQLiteSpy, I can clearly say that there is

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Ralf Junker
On 19.06.2013 17:18, Tom Holden wrote: > I use the SQLiteSpy compilation of SQLite3 which recently upgraded > from pre SQLite 3.7.8 to pre 4.2.0. You must be mistaken. As the author of SQLiteSpy, I can clearly say that there is no SQLiteSpy version 3.7.8 nor 4.2.0. The current version is

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Richard Hipp
On Thu, Jun 20, 2013 at 10:43 AM, Tom Holden wrote: > > Richard, I think I know why your test of the command line shell returned > no error – an index is needed on the field with the missing collation. I am > guessing what has changed is that the query optimiser now

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Tom Holden
(my apology for trying to reply to a message in the archive which has no reply-to feature – I hope it ends up in the right thread) Richard, I think I know why your test of the command line shell returned no error – an index is needed on the field with the missing collation. I am guessing what

Re: [sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Richard Hipp
On Wed, Jun 19, 2013 at 11:18 AM, Tom Holden wrote: > I use the SQLiteSpy compilation of SQLite3 which recently upgraded from > pre SQLite 3.7.8 to pre 4.2.0. I also occasionally use the SQLite3 Windows > command-line shell. I am now encountering an error with the current >

[sqlite] False Error 'no such collation sequence'

2013-06-20 Thread Tom Holden
I use the SQLiteSpy compilation of SQLite3 which recently upgraded from pre SQLite 3.7.8 to pre 4.2.0. I also occasionally use the SQLite3 Windows command-line shell. I am now encountering an error with the current versions that I did not with earlier ones – sorry, I cannot be precise at this