I think the problem may be with how much can be done in a single transaction. try db.commit() after each insert.
On May 18, 10:27 am, Berti <[email protected]> wrote: > The text size that actually causes the error is 1078 characters. I am > running a loop and inserting the whole mailbox with about 400 messages > into a database. At a specific number, in this case it is 97, the loop > stops by producing the error. I can delete that message from the > mailbox but than it is the next message that causes the error. > > On 18 Mai, 16:16, mdipierro <[email protected]> wrote: > > > How big is the text? > > > On May 18, 5:34 am, Berti <[email protected]> wrote: > > > > I am trying to insert the body of an email message in a SQLite3 > > > databse. > > > > But I get the error message: > > > > DataError: String or BLOB exceeded size limit > > > > I have declared the database field as text. If i declare it as string, > > > the body of the messsage is going to be inserted, but no in full > > > length. > > > > How can I insert the full text. What is the size limit for a text?
