odbcDataType

This is used when creating a new table with <code>dbWriteTable()</code>.
Databases with default methods defined are<ul>
<li>MySQL</li>
<li>PostgreSQL</li>
<li>SQL Server</li>
<li>Oracle</li>
<li>SQLite</li>
<li>Spark</li>
<li>Hive</li>
<li>Impala</li>
<li>Redshift</li>
<li>Vertica</li>
<li>BigQuery</li>
<li>Teradata</li>
<li>Access</li>
</ul>

A DBI-compatible interface to ODBC databases.

Hadley Wickham

odbc

Connect to ODBC Compatible Databases (using the DBI Interface)

Jim Hester

Oliver Gjoneski

lexicalunit 

Google Inc. 

Posit Software, PBC 

odbcDataType function

<dl><dt>con</dt>
<dd>A driver connection object, as returned by <code>dbConnect()</code>.</dd>
<dt>obj</dt>
<dd>An R object.</dd>
<dt>...</dt>
<dd>Additional arguments passed to methods.</dd></dl>

Arguments

The object type for your connection will be the database name retrieved by
<code>dbGetInfo(con)$dbms.name</code>. Use the documentation provided with your
database to determine appropriate values for each R data type. An example
method definition of a fictional <code>foo</code> database follows.
<div class="sourceCode"></div><pre><code>con &lt;- dbConnect(odbc::odbc(), "FooConnection")
dbGetInfo(con)$dbms.name
#&gt; [1] "foo"`odbcDataType.foo &lt;- function(con, obj, ...) {
 switch_type(obj,
 factor = "VARCHAR(255)",
 datetime = "TIMESTAMP",
 date = "DATE",
 binary = "BINARY",
 integer = "INTEGER",
 double = "DOUBLE",
 character = "VARCHAR(255)",
 logical = "BIT",
 list = "VARCHAR(255)",
 stop("Unsupported type", call. = FALSE)
 )
}
</code></pre>

Defining a new dbDataType method

Return the corresponding ODBC data type for an R object — odbcDataType

<dl>

<dt>con</dt>
<dd>A driver connection object, as returned by <code>dbConnect()</code>.</dd>


<dt>obj</dt>
<dd>An R object.</dd>


<dt>...</dt>
<dd>Additional arguments passed to methods.</dd>

</dl>

The object type for your connection will be the database name retrieved by
<code>dbGetInfo(con)$dbms.name</code>. Use the documentation provided with your
database to determine appropriate values for each R data type. An example
method definition of a fictional <code>foo</code> database follows.
<div class="sourceCode"><pre><code>con &lt;- dbConnect(odbc::odbc(), "FooConnection")
dbGetInfo(con)$dbms.name
#&gt; [1] "foo"

`odbcDataType.foo &lt;- function(con, obj, ...) {
 switch_type(obj,
 factor = "VARCHAR(255)",
 datetime = "TIMESTAMP",
 date = "DATE",
 binary = "BINARY",
 integer = "INTEGER",
 double = "DOUBLE",
 character = "VARCHAR(255)",
 logical = "BIT",
 list = "VARCHAR(255)",
 stop("Unsupported type", call. = FALSE)
 )
}
</code></pre></div>

odbcDataType: Return the corresponding ODBC data type for an R object

Description

Usage

Value

Arguments

Defining a new dbDataType method

Details