[R] sqlFetch on MySQL-DB

[Bernd Weiss]

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