SQLite Forum

SQLite diff tool doesn't work with CRLF new line characters
Login
If you pipe the output of that sqldiff.exe command into a file and then inspect the results with a hex editor or similar, does it look like well-formed utf-8?

Or, if you run:

        SELECT hex(tbl."Test Text") FROM "Test Table" AS tbl WHERE rowid=3

does it look like well-formed utf-8 or utf-16 text?

Dan.