[Bioc-devel] size limit of a string or a BLOB
Simon Lin wrote:
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)
+
Hi, Simon. I cannot comment directly on the RSQLite limits, but here is what SQLite says about limits: http://www.sqlite.org/limits.html Sean