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)
+