Just occurred to me: another problem with the BOM is that some people who are *not* writing UTF-8 are cargo-culting the BOM in anyway. So you may have to scan the whole file to see if it’s really UTF-8 anyway.
You’re better off just assuming UTF-8 everywhere, generating an error (and backing out the operation where possible) when you get a failure, and attacking the broken sources. OTOH, defensive programming says drop all the BOMs on input anyway. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users