Skip to content

does RMySQL support the MySQL String Column Type TEXT ?

3 messages · Armin S. A. Roehrl, Saikat DebRoy

Original
Armin S. A. Roehrl
# 
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
# 
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
# 
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._