Adam Wilson-4 wrote: > > I am running R 2.5.1, RMySQL 0.6 , and DBI 0.2-3 on Windows XP > > Like others, I am having trouble with NA/Null value conversions between R > and a MySQL database via DBI, but I could not find my exact problem in the > archives. Most of the time NA values in R get transferred correctly to > the > database and back again, unless (apparently) if they are in the last > column > of the table being saved. >
I have the R 2.5.0, RMySQL 0.6 , and DBI 0.2-3 on Linux and don't get this problem. What do you get running > str(x) > dbGetQuery(test,"describe x") Field Type Null Key Default Extra 1 X1 double YES <NA> 2 X2 double YES <NA> 3 X3 double YES <NA> 4 X4 double YES <NA> > dbGetInfo(test)$serverVersion [1] "5.0.41" Chris -- View this message in context: http://www.nabble.com/RMySQL-NA-NULL-value-storage-error-tf4531309.html#a12943167 Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
