Skip to content

RMysql and MySQL 5 Decimal Type Support

1 message · Jason Trimble

#
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