On 17 Feb 2014, at 4:57pm, Tim Streater <t...@clothears.org.uk> wrote:
> Thanks. I should perhaps have made it clearer that I'm looking at an issue a > user has. The application gathers some data from the user via a set of fields > they complete in a browser window, which data is then gathered up and sent > using ajax to be processed by a PHP script, which writes it to an sqlite db. > The user complains that some of this data doesn't make it, so I want to pin > down where in the chain this might be failing. Hence my Q. Ah. In that case it's more likely to be writing zero-length strings. In other words "a column into which no data has ever been entered" does not happen. I'm with Mister Beal and possibly yourself: your problem is outside of SQLite. My only answer is to convert to Unicode as fast as possible then handle everything with Unicode-safe APIs. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users