| 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 NAs 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)