Skip to contents

Return the corresponding ODBC data type for an R object

Source: R/aaa-odbc-data-type.R, R/driver-access.R, R/driver-bigquery.R, and 12 more
odbcDataType.Rd

This is used when creating a new table with dbWriteTable(). Databases with default methods defined are:

  • MySQL

  • PostgreSQL

  • SQL Server

  • Oracle

  • SQLite

  • Spark

  • Hive

  • Impala

  • Redshift

  • Vertica

  • BigQuery

  • Teradata

  • Access

  • Snowflake

Usage

odbcDataType(con, obj, ...)

Arguments

con

A driver connection object, as returned by dbConnect().

obj

An R object.

...

Additional arguments passed to methods.

Value

Corresponding SQL type for the obj.

Details

If you are using a different database and dbWriteTable() fails with a SQL parsing error the default method is not appropriate, you will need to write a new method. The object type for your method will be the database name retrieved by dbGetInfo(con)$dbms.name. Use the documentation provided with your database to determine appropriate values for each R data type.