-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: 10 April 2012 19:04 To: General Discussion of SQLite Database Subject: Re: [sqlite] Unicode problem when setting PRAGMA journal_mode
>> Realised I made a typo below: should have said "PRAGMA journal_mode = >> DELETE" (though setting it to WAL or OFF causes the same problem). > > Are you by any chance having a technical problem with the PRAGMA command > itself ? For instance, suppose the command was encoded in UTF-16 and SQLite > was expecting ASCII. Figure out what the default > value should be (e.g. use > the shell tool to do a "PRAGMA journal_mode;") then change your normal app to > set the mode to that value. See if it gives you the same problem. I'm not getting the same problem with other PRAGMA commands (quick_check(1) and synchronous=NORMAL), so I don't know why journal_mode would be any different. If I leave this one PRAGMA out, everything is fine. If I include it, the DB always fails to close. But only in Unicode. I'll try your suggestion of setting it to what it currently is (it *should* be DELETE) and see what it does. Thanks, Nick. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
