Armin S. A. Roehrl
2000-Aug-30 22:18 UTC
[Rd] does RMySQL support the MySQL String Column Type TEXT ?
Dear Mysql & R users, first of all a big thanks to the authors of RMySQL. I got the following table; mysql> describe UserClick; +----------------+-------------+------+-----+---------+-------+---------------------------------+ | Field | Type | Null | Key | Default | Extra | Privileges | +----------------+-------------+------+-----+---------+-------+---------------------------------+ | UseTransaction | varchar(20) | | | | | select,insert,update,references | | Engine | varchar(30) | | | | | select,insert,update,references | | URL | text | | | | | select,insert,update,references | +----------------+-------------+------+-----+---------+-------+----------------- I access it via: rs<-dbExecStatement(con,"SELECT * from UserClick") res<-fetch(rs) Things go wrong withthe URL entry which is of type text; $Engine [1] "Armintest" "Test" "Voila" $URL $URL[[1]] NULL ... Any ideas of how I could fix that would be highly appreciated. If it's not yet implemented, if you give me a few indications, I would implement it. Thanks, Armin -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-devel-request@stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Saikat DebRoy
2000-Aug-30 23:06 UTC
[Rd] does RMySQL support the MySQL String Column Type TEXT ?
>>>>> "Armin" == Armin S A Roehrl <Armin.Roehrl@epfl.ch> writes:Armin> Dear Mysql & R users, first of all a big thanks to the Armin> authors of RMySQL. Armin> I got the following table; mysql> describe UserClick; Armin> +----------------+-------------+------+-----+---------+-------+---------------------------------+ Armin> | Field | Type | Null | Key | Default | Extra | Privileges | Armin> +----------------+-------------+------+-----+---------+-------+---------------------------------+ Armin> | UseTransaction | varchar(20) | | | | | Armin> select,insert,update,references | | Engine | varchar(30) | | Armin> | | | select,insert,update,references | | URL | text | | | | Armin> | select,insert,update,references | Armin> +----------------+-------------+------+-----+---------+-------+----------------- Armin> I access it via: rs<-dbExecStatement(con,"SELECT * from Armin> UserClick") res<-fetch(rs) Armin> Things go wrong withthe URL entry which is of type text; Armin> $Engine [1] "Armintest" "Test" "Voila" $URL $URL[[1]] NULL Armin> ... Armin> Any ideas of how I could fix that would be highly Armin> appreciated. If it's not yet implemented, if you give me a Armin> few indications, I would implement it. Armin> Thanks, Armin We have a newer version of the MySQL package (currently working in S). This may solve your problem. I am currently working on another project but I would do the R port of the latest MySQL package in a few days. -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-devel-request@stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
Armin S. A. Roehrl
2000-Aug-30 23:21 UTC
[Rd] does RMySQL support the MySQL String Column Type TEXT ?
> We have a newer version of the MySQL package (currently working in S). > This may solve your problem. I am currently working on another project > but I would do the R port of the latest MySQL package in a few > days.Brilliant! Looking forward to that. Armin -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.- r-devel mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html Send "info", "help", or "[un]subscribe" (in the "body", not the subject !) To: r-devel-request@stat.math.ethz.ch _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._