oh really - I didn't realize that would ever be a problem. Is it practical to have the DAL auto-commit before too much data is built up?
On May 19, 1:49 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > 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 <p...@berci.net> 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 <mdipie...@cs.depaul.edu> wrote: > > > > How big is the text? > > > > On May 18, 5:34 am, Berti <p...@berci.net> 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?
