[R-sig-DB] Fwd: rmysql and strings containg \n

[H. Felix Wittmann]

Hi Jeff,

thanks for your answer. At the moment I've got the following

R version 2.9.2 (2009-08-24)
‘RMySQL’ version 0.7-4
mysql  Ver 14.12 Distrib 5.0.75, for debian-linux-gnu (x86_64) using
readline 5.2

That said, similar things have consistently shown up in pretty much
all the environments that I've tested.

Felix


2009/10/26 Jeffrey Horner <jeff.horner using vanderbilt.edu>
>
> Hi H. Felix Wittmann,
>
> We require that you tell us R's version, RMySQL's version, and MySQL's version upon which you are running your code. Then we can better determine if your problem is a bug or a feature.
>
> Best,
>
> Jeff
>
> H. Felix Wittmann wrote on 10/20/2009 04:37 PM:
>>
>> I' ve noticed a few typos in my previous post therefore I send a
>> cleaned up version
>>
>>
>> require(RMySQL)
>>
>> m <- dbDriver("MySQL")
>> myCon <- dbConnect(m,group = 'whateverGroup')
>> # replace this (ie 'whateverGroup') by the appropriate group specified
>> in your my.cnf file
>> # on a typical UBUNTU installation you can
>> # modify this using the command line editor (eg bash) by this command
>> # sudo nano /etc/mysql/my.cnf
>>
>> test <- data.frame(id=1,myString='beginning1 \n end1')
>> # the above line produces (this is what the output should like like) :
>> # > test
>> #   id           myString
>> # 1  1 beginning1 \n end1
>>
>> dbWriteTable(myCon,name='test', value=test)
>> dbReadTable(myCon,name='test')
>> # the above line produces (here we can see that the output is not the
>> same as above) :
>> #       id    myString
>> # 1      1 beginning1
>> #  end1 NA        <NA>
>>
>>
>> H. Felix Wittmann
>>
>> _______________________________________________
>> R-sig-DB mailing list -- R Special Interest Group
>> R-sig-DB using stat.math.ethz.ch
>> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>
>
> --
> http://biostat.mc.vanderbilt.edu/JeffreyHorner