Re: [R] sqlFetch on MySQL-DB

From: Bernd Weiss <bernd.weiss_at_uni-koeln.de>
Date: Tue 11 Oct 2005 - 00:58:27 EST

Am 10 Oct 2005 um 7:51 hat christian schulz geschrieben:

> Hi,
>
> there is a problem with the type of attributes - is it varchar!? IMHO
> you should play a bit with different type's in mysql and the
> consequence in R.
>
> I recognize "similar" problems with RMySQL, if you have variables
> with type decimal in mysql you get numerics in chr. But it's possible
> to change the decimal in double (mysql) to get num in R.

Thanks to Christian Schulz and Prof. Ripley for their valuable suggestions. The use of

        author<-sqlFetch(test,"author",as.is=17)

does the job without any problems.

Bernd



R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Oct 11 01:12:28 2005

This archive was generated by hypermail 2.1.8 : Sun 23 Oct 2005 - 18:37:30 EST