It looks that the "MS SQL" is not recognized by the DBI::dbQuoteString()
as a valid SQL dialect.
I am not using directly the DBI::dbQuoteString()
, but I was trying to use the glue::glue_sql()
instead to construct the SQL querries.
The apostrophe is used as the (') as quotation character, but the MS SQL Server accepts the double quotation mark (") (or the square brackets) as quotation characters.
library(tidyverse)
library(odbc)
con <-
dbConnect(odbc(),
# Microsoft ODBC Driver for SQL Server on Windows
driver = "SQL Server",
.....)
DBI::dbQuoteString(conn = con, "res")
#> <SQL> 'res'
How can I overwrite the quotation character or what type of connector should I define/use?