R help - Jul 2007 - hi, about mysql from r

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]]