Message-ID: <46FDDEE4.3030007@duke.edu>
Date: 2007-09-29T05:13:08Z
From: Simon Lin
Subject: [Bioc-devel] size limit of a string or a BLOB
In-Reply-To: <mailman.21.1190887204.1151.bioc-devel@stat.math.ethz.ch>
I have got the following error message when using RSQLite. So, what is
the size limit of a string? and what is the limit of the BLOB (by
defination, I assume it shoud be in the TB range at least)? Thanks! -Simon
# trying to insert a DNA sequence of about 500MB into a table
> query01<-dbSendQuery(connect, statement = paste ("
+ insert into dna values ('", seq0, "')", sep="")
+ )
Error in sqliteExecStatement(conn, statement, ...) :
RS-DBI driver: (error in statement: String or BLOB exceeded size limit)
+