New try with this one :
dbWriteTable(con,
name = "ci_diplomes",
value = ci_diplomes,
field.types = c(`code-diplome`="varchar(3000)",
`code-type-diplome`="varchar(3000)",
`code-niveau-europeen`="varchar(3000)",
`code-rncp`="varchar(3000)",
`code-scolarite`="varchar(3000)",
`code-sise`="varchar(3000)",
`code-onisep`="varchar(3000)",
`code-onisep-ideo`="varchar(3000)",
`code-specificite-ideo`="varchar(3000)",
`code-cqp`="varchar(3000)",
`code-ministere-emploi`="varchar(3000)",
`code-afpa`="varchar(3000)",
`code-nsf`="varchar(3000)",
`code-lettre-nsf`="varchar(3000)",
`code-carif-07`="varchar(3000)",
`code-carif-26`="varchar(3000)",
`inscrit-rncp`="varchar(3000)",
`type-sigle`="varchar(3000)",
`type-complet`="varchar(3000)",
`intitule-diplome`="varchar(3000)",
`dominante`="varchar(3000)",
`mention`="varchar(3000)",
`specialite`="varchar(3000)",
`intitule-sigle`="varchar(3000)",
`code-niveau-entree`="varchar(3000)",
`accessibilite-fi`="varchar(3000)",
`accessibilite-ca`="varchar(3000)",
`accessibilite-fc`="varchar(3000)",
`accessibilite-cp`="varchar(3000)",
`accessibilite-vae`="varchar(3000)",
`accessibilite-ind`="varchar(3000)",
`accessibilite-uc`="varchar(3000)",
`valideur`="varchar(3000)",
`annee-premiere-session`="varchar(3000)",
`annee-derniere-session`="varchar(3000)",
`code-apogee`="varchar(3000)",
`etat`="varchar(3000)",
`date-creation`="varchar(3000)",
`date-maj`="varchar(3000)",
`validation-interne`="varchar(3000)",
`validation-alfa`="varchar(3000)")
)
Still does not work :
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