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.

Reply via email to