Displaying 1 result from an estimated 1 matches for "id_evenement".
2010 Mar 25
1
RODBC : reading binary data from a TXT field belonging to a PostgeSQL table
...9;,1,'",paste(bytes[1:10000],collapse=" "),"')",sep=""))
##
## 3. Data Extraction
##
## The problem is here : sqlQuery command doesn't give the same
amount of bytes
##
bytes.out <- sqlQuery(ch, paste("SELECT data FROM tabsignal WHERE
id_evenement=1"),stringsAsFactors=FALSE)
bytes.out <- unlist(strsplit(bytes.out[1,1],split=" +"))
bytes.out <- as.raw(bytes.out)
length(bytes.out) ## bytes.out is shorter than bytes !!! although data
is well-stored in the database.
## 4. End of the connection
close(ch)
Thank you very mu...