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

Reply via email to