From ripley at stats.ox.ac.uk  Wed Mar 29 08:07:59 2006
From: ripley at stats.ox.ac.uk (ripley at stats.ox.ac.uk)
Date: Wed, 29 Mar 2006 08:07:59 +0200 (CEST)
Subject: [Rd] RS-DBI does not recognized MySQL decimals (PR#8723)
Message-ID: <20060329060759.B53F041EC3@slim.kubism.ku.dk>

  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.

--27464147-1125417764-1143612462=:26272
Content-Type: TEXT/PLAIN; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: 8BIT

Please read the FAQ, and report problems in contributed packages to the 
maintainer and not R-bugs, as we ask.

I suspect the problem is in RMySQL, but the maintainer is the same as for 
DBI.

On Tue, 28 Mar 2006, jtrimble at bodymedia.com wrote:

> Full_Name: Jason Trimble
> Version: 2.2.1
> OS: Windows XP and RedHat EL4
> Submission from: (NULL) (209.166.128.18)
>
>
> Whenever a MySQL query 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? 
anything that returns a
> decimal!
>
> Application version are:
> R ver 2.1.1
> RMySQL ver. 0.5-7
> DBI ver. 0.1-10
> MySQL  Ver 14.12 Distrib 5.0.18.
>
> ______________________________________________
> R-devel at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-devel
>
>

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595
--27464147-1125417764-1143612462=:26272--



[Rd] RS-DBI does not recognized MySQL decimals (PR#8723)
ripley at stats.ox.ac.uk