Re: [sqlite] SQL_STATIC unterminated strings, and sqlite3_result_text

Sorry to threadjack here, but this made me think of something... Does this mean that sqlite3_column_text always makes a copy of the string to put a null terminator on the end? My ORM uses std::strings in UTF8 everywhere, so does that mean it would be quite a bit faster to pull strings out

Re: [sqlite] SQL_STATIC unterminated strings, and sqlite3_result_text

On Sun, Dec 15, 2013 at 6:04 PM, James K. Lowden wrote: > http://www.sqlite.org/c3ref/result_blob.html > > I found a documentation typo and have a question about SQLITE_STATIC. > > The documentation for sqlite3_result_text says, > > "If the 3rd parameter is

[sqlite] SQL_STATIC unterminated strings, and sqlite3_result_text

http://www.sqlite.org/c3ref/result_blob.html I found a documentation typo and have a question about SQLITE_STATIC. The documentation for sqlite3_result_text says, "If the 3rd parameter is non-negative, then it must be the byte offset into the string where the NUL terminator would

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

On Sun, 15 Dec 2013 07:28:52 -0800 (PST), margave wrote: >Addendum: I ran "file" on sqlite3.exe ... > >On computer B (where sqlite3 works): PE32 executable (console) Intel 80386, >for MS Windows >On computer A (where it does not): PE32+ executable (console) x86-64, for >MS

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

2013/12/15 margave : > I noticed that the sqlite3.exe file on computer A has a different cksum than > the one on computer B. (Seems odd! The Cygwin installer shows the same > version on both!) Which version? SQLite 3.8.2-2? Apparently, you are running Cygwin on A and Cygwin64 on

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

Addendum: I ran "file" on sqlite3.exe ... On computer B (where sqlite3 works): PE32 executable (console) Intel 80386, for MS Windows On computer A (where it does not): PE32+ executable (console) x86-64, for MS Windows -- View this message in context:

Re: [sqlite] An "unable to open database file" error that has nothing to do with opening database file

I have the same problem. I have .sqlite db files, and I wish to read them with sqlite3.exe (under Cygwin x64 on Win 7 x64). I want this to work on both computer A and computer B. (Both have the same Win 7 and Cygwin installed). But it only works on computer B, not on computer A. I have the SAME