DBI - field.types = varchar(max) for all columns ?

[Fabian_CO]

Hi everybody,

I try to write a dataframe in a SQL Server table with all fields with varchar(max) but i don't find the correct code... My dataframe contains lot of fields, so it's quiet long to specify type for each field...

My R code below :

dbWriteTable(con, 
             name = "ci_td", 
             value = ci_tdip,
             file_encoding ="latin-1",
             field.types="varchar(max)", # here is my problem, I know this is not correct, it's just for explain...
             overwrite=TRUE)

Any idea please ?

Thank you for your help,

[nirgrahamuk]

@Fabian_CO

"varchar(max)"

I think you are asking for something like

#for example data 
ci_tdip <- iris


(myvec <- rep("varchar(max)",ncol(ci_tdip )))
names(myvec) <- names(ci_tdip )
myvec

dbWriteTable(con, 
             name = "ci_td", 
             value = ci_tdip,
             file_encoding ="latin-1",
             field.types=myvec
             overwrite=TRUE)

but feel free to clarify

[Fabian_CO]

It works fine thank you !