Determine the SQL Data Type of an S object

Source: R/data-type.R

This method is a straight-forward implementation of the corresponding generic function.

# S4 method for class 'MySQLDriver'
dbDataType(dbObj, obj)

# S4 method for class 'MySQLConnection'
dbDataType(dbObj, obj)

Arguments

dbObj

A MySQLDriver or MySQLConnection.

obj

R/S-Plus object whose SQL type we want to determine.

Examples

dbDataType(RMySQL::MySQL(), "a")
#> [1] "text"
dbDataType(RMySQL::MySQL(), 1:3)
#> [1] "bigint"
dbDataType(RMySQL::MySQL(), 2.5)
#> [1] "double"