Hi, I'm trying to get data from a MS SqlServer database into R, using the RODBC package. The problem I've found is that numeric data from my sql queries is returned with only two decimal digits.
After searching the docs, I think the problem comes from my sql numeric data having "float" type instead of "double", as I found the following: "Where possible sqlGetResults transfers data directly: this happens for double, real, integer and smallint columns in the table. All other SQL data types are converted to character strings (of length up to 256), and then converted by type.convert as controlled by the as.is argument." What I did not found was a way to get back more than two decimal digits in this character-numeric transformation. I would acknowledge any clue as to whether this is possible. Thanks in advance! Enrique ___________________________________________________________________________ Enrique Bengoechea Investment Consulting - CREDIT SUISSE Spain ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
