[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