[R] RMySQL typing Problem (bigint unsigned)

From: Dubravko Dolic <Dubravko.Dolic_at_komdat.com>
Date: Mon 04 Jul 2005 - 23:50:34 EST

Dear Group,  

if anyone has experience with the RMySQL Package maybe this behaviour is know:  

Reading data from a table into R the fields with datatype bigint(20) unsigned are transformed in some way: e.g. the query "select * from orders where userid = 14929859848712890325" selects the correct case but in R the userid is changed to 14929859848712890368. What happened here? This transformation is true for all fields of that type...  

Thank You for any help          

Dubravko Dolic

Statistical Analyst

Tel: +49 (0)89-55 27 44 - 4630

Fax: +49 (0)89-55 27 44 - 2463

Email: dubravko.dolic@komdat.com

Komdat GmbH
Nymphenburger Straße 86
80636 München


This electronic message contains information from Komdat Gmb...{{dropped}}

R-help@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 Received on Mon Jul 04 23:54:08 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:33:11 EST