CLOB processing using the Jite adapter for SQLite

Question

When I look at SQLite DB, it says it's a CLOB type, however, when I try to use the getClob method, I see the following ....

"not implemented by SQLite JDBC driver"

So should I use String? Should I use UTF-8 or what type of encoding should I use? Value is HTML with a possible inline image.

Answer 1

Now the answer seems to be using String.

I tried this and the photos taken in Swing. The best answer gets a check.