From Armin.Roehrl@epfl.ch  Wed Aug 30 23:18:48 2000
From: Armin.Roehrl@epfl.ch (Armin S. A. Roehrl)
Date: Thu, 31 Aug 2000 00:18:48 +0200
Subject: [Rd] does RMySQL support the MySQL String Column Type TEXT ?
Message-ID: <39AD8848.B272885D@epfl.ch>

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


[Rd] does RMySQL support the MySQL String Column Type TEXT ?
Armin S. A. Roehrl