Displaying 1 result from an estimated 1 matches for "td2324503".
2011 Jul 27
2
RODBC sqlSave problem with bigint numbers
...se.
The main command is
sqlSave(channel, data_df, tablename, append=T, rownames=FALSE,
colnames=FALSE, fast=FALSE, varTypes=vartypes)
where data_df is the data.frame I want to save and vartypes is obtained
following the tip given here
http://r.789695.n4.nabble.com/some-helpful-tips-on-using-RODBC-td2324503.html
Useful Tips for RODBC
Two columns have a bigint unsigned type.
The first contains numbers with 11 figures (like 20015301001)
The second colums has numbers with 13 figures (like 2002000103651)
First column are well saved in the database but, even with the same type,
numbers of the second one...