Michael Geier wrote: > > Using "PRAGMA temp_store_directory = 'directory-name';" with paths which > contain non-ASCII characters doesn't work because SQLite reports the > directory as not writable (SQLite.Net.SQLiteException: "not a writable > directory"). >
When passing strings of any kind to the SQLite C API functions, it is very important that they be correctly formed UTF-8. Unfortunately, I'm not too familiar with the "sqlite-net" project and I do not know how they are doing these string conversions (e.g. from UTF-16 to UTF-8). Are you able to provide an example UTF-8 byte sequence that demonstrates the problem when passed into the SQLite C API? -- Joe Mistachkin
