On 10 February 2016 at 11:14, <david at andl.org> wrote: > >>>Every SQLite database file has a text encoding that applies to the > entire > file: one of utf8, utf16be, or utf16le. The database text encoding is > stored in the header. You can see the encoding for a particular database > using: > > sqlite3 DATABASE.db .dbinfo > > >>>(NB: The ".dbinfo" command is relatively recent, so you'll want the > latest version of sqlite3.exe for this to work.) > > Mine is 3.8.6 2014-08-15 11:46:33 9491ba7d738528f168657adb43a198238abde19e. > I guess I need something newer. That does explain why I couldn't find out. >
"PRAGMA encoding;" seems to do the trick in earlier versions (3.8.1 here). -Rowan
