[R] RODBC : how to avoid truncatig big integer when using sqlsave

PtitBleu ptit_bleu at yahoo.fr
Fri Feb 4 15:22:17 CET 2011


Hello,

I'm still trying to modify my script in order to use RODBC instead of RMySQL
(no more ready-to-use package for windows).

My new problem is the following one (not seen with RMySQL):

I'd like to copy a data.frame to a mysql table. One column is a numeric one
with big integer like :
2005000206110 (13 figures)
If I type this number in R, I get:
2.005e+12
and when I use sqlSave to save the data, in the MySQL table I get (the type
of the column is bigint(13)): 
2005000000000 instead of 2005000206110

I tried with varType = bigint unsigned for this column but it doesn't work.

Is there a way to save the number with all the figures?
Thanks in advance.
Have a nice week-end,
Ptit Bleu.
-- 
View this message in context: http://r.789695.n4.nabble.com/RODBC-how-to-avoid-truncatig-big-integer-when-using-sqlsave-tp3260251p3260251.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list