Why R dataframe export to SQL Server does not work?

Question

I try to push an R table to an SQL Server database, here my script:

dbWriteTable(con, 
             name = "ci_d", 
             value = ci_d, 
             field.types = c(`thing`="varchar(3000)",
                             `notes`="varchar(3000)"
             )

and the error message :

Error in result_insert_dataframe(rs@ptr, values, batch_rows) :
nanodbc/nanodbc.cpp:1655: 22001: [Microsoft][ODBC SQL Server Driver]Troncation à droite de la cha?ne de données

Google translation from French: "Right truncation of the data string"

Anyone has an idea to solve this ?

question from:https://stackoverflow.com/questions/66064366/why-r-dataframe-export-to-sql-server-does-not-work

Answer 1

Waitting for answers