[SQLiteJDBC] Saving large amount of text into sqlite using TEXT data type

[Melvin Dave Vivas]

Hi Guys,

I'm encountering a problem inserting large amount of text in sqlite using a
TEXT data type. I am using a prepared statement to do this.

Here is my code:

PreparedStatement ps = conn.prepareStatement("INSERT INTO
MY_TABLE(LARGETEXT) VALUES(?)");

ps.setString(1,article.getContent());
ps.execute()
...

Some text are truncated and not saved into the database.

Am I doing something wrong here?

Thanks!

Melvin
---

Follow me in Twitter! - http://twitter.com/donvito