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

