--- Murphy <[EMAIL PROTECTED]> wrote:
> > Might this be a SQLite bug?
>
> OK, I rest my case. The "bug" is intended behaviour, according to the
> maintainer (http://www.sqlite.org/cvstrac/tktview?tn=2461,36), and
> trying again with SQLiteJDBC and a UTF-16 encoded DB I can now
> retrieve the BLOB correctly, though I (think I) have tested the
> misbehaviour intenesely before and didn't change anything on the
> relevant code since then... :-(
Encoding only plays a role for TEXT columns.
You may have been retrieving the blob column as a text string.
If by chance you can recreate the problem, please post a complete
self-contained JDBC program that demonstrates it.
____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search
that gives answers, not web links.
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---