Displaying 1 result from an estimated 1 matches for "no_backslash_escap".
Did you mean:
no_backslash_escape
2008 Aug 11
1
Unwanted carriage returns storing dataframes with dbWriteTable
...table in the database will have a '\r' (carriage return)
appended. If I read back the dataframe with dbReadTable the last column
in the resulting dataframe has also '\r' appended (see protocol below).
Setting or unsetting sql-mode (in the SQL-Server Version 5.0) to or from
'NO_BACKSLASH_ESCAPE' has no effect on this behavour ? How can I avoid
these unwanted '\r'-tail ?
Hansruedi
> df1
a c
a 1 x
b 2 y
c 3 z
d 4 t
> dbWriteTable(con,"df1",df1,row.names=FALSE)
[1] TRUE
> df1=dbReadTable(con,"df1")
> df1
a c
1 1 x\r
2 2 y\r
3 3 z\r
4 4 t...