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

-help@stat.math.ethz.ch Subject: Re: [R] R, RMysql, and MySQL 5 Decimal Type Support 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

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

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.

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

of Health Science 800 W. Jefferson St. Kirksville, MO 63501-1497 USA - Original Message - From: Jason Trimble [EMAIL PROTECTED] To: r-help@stat.math.ethz.ch Sent: Tuesday, March 28, 2006 12:08 PM Subject: [R] R, RMysql, and MySQL 5 Decimal Type Support Hi, I am using: R ver

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

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