On 22 Mar 2013, at 3:04pm, Tim Streater <t...@clothears.org.uk> wrote:

> Having checked the db carefully, both using hex(col) (via the sqlite3 CLI 
> program), and using the unix hexdump utility on the db, I'm now reasonably 
> certain that the C2 bytes are simply not in the db. That they show up when I 
> examine the db with Navicat for SQLite Lite is another matter altogether.

The moral of the story (for anyone else finding this thread when googling to 
solve their own problem) is not to trust third-party software.  Write your own 
code or use the sqlite3 executable provided by the sqlite development team.  
Oh, and I should have thought of hex() myself.  Bad Simon.  No cookie.

> Sorry for the distraction.

I assume that means you have no more sqlite3-related problem.  Glad we could 
help.  Good luck with the rest of your project.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to