hi,
I am using the R connect to mysql by RODBC, windows XP. when I use sqlQuery()
to select blob columns from table, the result is binary type. but what i put
into the blob column is character. and when using Perl, it is ok.
i change the column data type to longtext. but this time, the sqlQuery() just
gives me 255 characters.
so, how can i do?
this column composite with many numeric data, separated by ",". i just use the
ID index to select this big field, about 24KB each field.
this is the first time i use mailing list. hehe
thanks in advance!
whhu
2007-07-18
[[alternative HTML version deleted]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.