Re: [sqlite] Trying to use in-memory database
Richard Hipp wrote: > On Wed, Feb 19, 2014 at 5:25 PM, Jeff Archer < > jsarc...@nanotronicsimaging.com> wrote: > >> Long time SQLite user but I don't think I have ever tried to do an >> in-memory database before. >> Just upgraded to 3.8.3.1 but I am not having any other failures with >> existing code so I don't think that is any part of the problem. >> I am trying to open the database with sqlite3_open16() using a filename of >> L":MEMORY:". I am getting a result code of 14 which is SQLITE_CANTOPEN. >> It does open if I use a real filename. > > The magic name is case-sensitive and lower-case. Use L":memory:" and it > should work for you. ... and also note that passing L"..." string constants (and everything else of `wchar_t *` type) to sqlite3_*16() *very* bad idea (on nearly all non-windows platforms wchar_t is 32-bit int ucs-32, sqlite3_*16() expects 16-bit/utf-16, depending on platform endianness it will try to open ":" [which will silently succeed, but open *on-disk* database in current directory, extremely nasty!] or "" [which will likely fail]). ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Trying to use in-memory database
On Wed, Feb 19, 2014 at 5:25 PM, Jeff Archer < jsarc...@nanotronicsimaging.com> wrote: > Long time SQLite user but I don't think I have ever tried to do an > in-memory database before. > Just upgraded to 3.8.3.1 but I am not having any other failures with > existing code so I don't think that is any part of the problem. > I am trying to open the database with sqlite3_open16() using a filename of > L":MEMORY:". I am getting a result code of 14 which is SQLITE_CANTOPEN. > It does open if I use a real filename. > The magic name is case-sensitive and lower-case. Use L":memory:" and it should work for you. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Trying to use in-memory database
Long time SQLite user but I don't think I have ever tried to do an in-memory database before. Just upgraded to 3.8.3.1 but I am not having any other failures with existing code so I don't think that is any part of the problem. I am trying to open the database with sqlite3_open16() using a filename of L":MEMORY:". I am getting a result code of 14 which is SQLITE_CANTOPEN. It does open if I use a real filename. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users