setSqlTypeInfo

0th

Percentile

Specify or Query a Mapping of R Types to DBMS Types

Specify or retrieve a mapping of R types to DBMS datatypes.

Keywords
IO, database
Usage
setSqlTypeInfo(driver, value)

getSqlTypeInfo(driver)

Arguments
driver

A character string specifying the DBMS_name as returned by odbcGetInfo. Optional for getSqlTypeInfo.

value

A named list with character values. This should have names "double", "integer", "character" and "logical", and values SQL types appropriate to the DBMS.

Details

This information is used by sqlSave if it creates a table in the DBMS and is not overridden by arguments typeInfo or varTypes. Mappings are included for MySQL, PostgreSQL, SQLite, Oracle, Mimer, DB2 on Windows, and the Microsoft SQL Server, Access, Excel and Dbase drivers.

The SQL types chosen should be nullable to allow NAs to be represented. (Bit and boolean types often are not.)

Value

For setSqlTypeInfo none.

For getSqlTypeInfo with an argument, a named list. Without an argument, a data frame.

See Also

sqlTypeInfo, sqlSave.

Aliases
  • setSqlTypeInfo
  • getSqlTypeInfo
Examples
# NOT RUN {
getSqlTypeInfo()
getSqlTypeInfo("MySQL")
setSqlTypeInfo("Microsoft SQL Server",
               list(double="float", integer="int",
                    character="varchar(255)", logical="varchar(5)"))
# }
Documentation reproduced from package RODBC, version 1.3-15, License: GPL-2 | GPL-3

Community examples

Looks like there are no examples yet.