[R] raw object into mysql blob column
Christian Schulz
chschulz at email.de
Fri Jul 10 14:04:29 CEST 2009
Hi,
exist a possibility write a raw object into a mysql blob column?
My first trial and a second with a rawToChar after .jserialize didn't work.
mobj <- .jserialize(model)
> str(mobj)
raw [1:203761] ac ed 00 05 ...
sqlstring=paste("Insert into testtable (varname,number,model)
values(",modelName,",",modelID,",",mobj,")",sep="",collapse="")
#con is a RJDBC Connection
dbSendUpdate(con,sqlstring)
Thanks for advance
Christian
More information about the R-help
mailing list