[R] R, RMysql, and MySQL 5 Decimal Type Support

[David James]

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]]
> 
> ______________________________________________
> R-help at 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