rsqlserver icon indicating copy to clipboard operation
rsqlserver copied to clipboard

How to specify "encoding"

Open ChanningWong opened this issue 11 years ago • 1 comments

I've tried to set "encoding/Encoding/DBMSencoding" = "GBK" in url/dbConnect()/dbSendQuery()/fetch() but failed. Is there any parameters to specify character encoding?

-- code --

library("rsqlserver")
url = "Server=192.168.1.101;user=sa;password=**;Database=mydata;Trusted_Connection=True"
conn <- dbConnect("SqlServer", url = url)
a = dbSendQuery(conn, "SELECT TOP 5 *  FROM [mydata].[dbo].[data]")
fetch(a)

ChanningWong avatar Nov 18 '14 14:11 ChanningWong

What do you mean by encoding here ?

agstudy avatar Dec 13 '14 22:12 agstudy