Hi, MySQL data type 246 is the new (as of version 5.0?) fixed precision DECIMAL type, which doesn't map to any existing R type. In most cases, I believe, it is imported as an R character vector, and you can just coerce it to numeric, i.e., to floating point precision.
Next version of RMySQL will address this issue, and comments regarding what would be a suitable R type for SQL fixed DECIMALs are welcome. -- David Jason Trimble wrote: > Hi, > > > > Whenever I have a MySQL query that returns a Decimal result to R I get > the following warning in R: > > > > Warning message: > > RS-DBI driver warning: (unrecognized MySQL field type 246 in column 1) > > > > I get this for a simple query like "SELECT 2, 2.5" !! > > > > I am using: > > R ver 2.1.1 > > RMySQL ver. 0.5-7 > > DBI ver. 0.1-10 > > MySQL Ver 14.12 Distrib 5.0.18. > > > > Please Help! > > Jason > > > > [[alternative HTML version deleted]] > > ______________________________________________ > [email protected] mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
