setSqlTypeInfo {RODBC} | R Documentation |
Specify or retrieve a mapping of R types to DBMS datatypes.
setSqlTypeInfo(driver, value) getSqlTypeInfo(driver)
driver |
A character string specifying the driver as returned by
odbcGetInfo . Optional for getSqlTypeInfo . |
value |
A named list with character values. This should have
names "double" , "integer" , "character" and
"logical" . |
This information is used by sqlSave
if it creates a
table in the DBMS.
The types chosen should be nullable to allow NA
s to be
represented. (Bit and boolean types generally are not.)
For setSqlTypeInfo
none.
For getSqlTypeInfo
with an argument, a named list. Without an
argument, a data frame.
Brian Ripley
## Not run: getSqlTypeInfo() getSqlTypeInfo("MySQL") setSqlTypeInfo("SQLServer", list(double="float", integer="int", character="varchar(255)", logical="varchar(5)")) ## End(Not run)