From saikat@stat.wisc.edu  Thu Aug 31 00:06:28 2000
From: saikat@stat.wisc.edu (Saikat DebRoy)
Date: 30 Aug 2000 18:06:28 -0500
Subject: [Rd] does RMySQL support the MySQL String Column Type TEXT ?
In-Reply-To: "Armin S. A. Roehrl"'s message of "Thu, 31 Aug 2000 00:18:48 +0200"
References: <39AD8848.B272885D@epfl.ch>
Message-ID: <qxp7l8y8i2z.fsf@verdi.stat.wisc.edu>

>>>>> "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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._


[Rd] does RMySQL support the MySQL String Column Type TEXT ?
Saikat DebRoy