Specify or retrieve a mapping of R types to DBMS datatypes.
1 2 3
A character string specifying the
A named list with character values. This should have
This information is used by
sqlSave if it creates a
table in the DBMS and is not overridden by arguments
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.)
getSqlTypeInfo with an argument, a named list. Without an
argument, a data frame.
1 2 3 4 5 6 7 8
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.