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?
