Re: [sqlite] Path Length Limit on Windows

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 22/08/13 07:38, Markus Schaber wrote: > http://www.mail-archive.com/sqlite-users@sqlite.org/msg18707.html > seems to indicate that SQLite is not using those APIs. On the other > hand, that post is of 2006. There has been an open ticket about this

Re: [sqlite] BETWEEN and explicit collation assignment

You are correct, James, comparison depends on types. However, lets say we have suitcase and we want to test if it is bigger than the allowed limit, i.e. we have a biggest allowed suitcase to compare against. How do we answer: is this one bigger than the standard? Well, if this is a check-in

Re: [sqlite] Path Length Limit on Windows

Hi, Richard, Von: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Thu, Aug 22, 2013 at 10:38 AM, Markus Schaber wrote: > > During our internal tests, I recently stumbled across a problem when > > using SVN, which uses SQLite to manage the

Re: [sqlite] Path Length Limit on Windows

On Thu, Aug 22, 2013 at 10:38 AM, Markus Schaber wrote: > Hi, > > During our internal tests, I recently stumbled across a problem when > using SVN, which uses SQLite to manage the "wc.db" metadata database > in the working copy. > > SVN itself uses the Apache APR as PAL,

Re: [sqlite] Python -> Sqlite3 import, can't retrieve values in the last column

Thank you for the tip with the numbered rows, Simon (everything worked fine in the shell) -- But I just discovered that my problem was caused by a \n character that my script failed to strip -- Dr. Marten Düring Digital Humanities Researcher Centre Virtuel de la Connaissance sur l’Europe

Re: [sqlite] Python -> Sqlite3 import, can't retrieve values in the last column

On 23 Aug 2013, at 1:48pm, m.duering wrote: > However I only get one result if I run the query > SELECT * FROM nodes WHERE Netzwerk="Kaufmann" SQLite uses single quotes to surround strings. Should be: SELECT * FROM nodes WHERE Netzwerk='Kaufmann' > This works ok

[sqlite] Python -> Sqlite3 import, can't retrieve values in the last column

Hi all, this is my first project using Sqlite3 so I might have done something silly along the way. I can not run queries for the last columns of my tables. I either get only the very last row or nothing where there should be hundreds of entries which match the query. Here is what I did: I

[sqlite] Path Length Limit on Windows

Hi, During our internal tests, I recently stumbled across a problem when using SVN, which uses SQLite to manage the "wc.db" metadata database in the working copy. SVN itself uses the Apache APR as PAL, which internally uses the Windows Unicode APIs with the \\?\ path prefix, allowing path

[sqlite] Memory use and release on statement prepare

Hi, Encountered what seemed to be somewhat excessive memory consumption for a relatively simple statement prepare. The following was carried out in sequence. Platform/environment is Windows CE. 1. System and SQLite memory statistics obtained and recorded 2. Preparation of SQLite statement. The