Getting data from SQL Database to R

Asked Jun 03 '22 at 04:59

Active Jun 03 '22 at 12:53

Viewed 77 times

I see a weird error while extracting data from SQL to R. Only of the columns in SQL dataset has 40,000 character (nvarchar(MAX)) .

But when I extract this data to R using odbcDriverConnect(paste("driver={ODBC Driver 17 for SQL Server};_____")), I only 255 characters.

Howeverwhen I extract this data to R using odbcDriverConnect(paste("driver={SQL Server};_____")), I get all 40,000 characters.

Not sure why this is happening. Can anyone help?

edited Jun 03 '22 at 12:53

r2evans

asked Jun 03 '22 at 04:59

manu p

Does this change to your SQL query help: https://stackoverflow.com/a/12097781/18309711 – Jun 03 '22 at 05:48
Unfortunately No :( – manu p Jun 03 '22 at 06:38
You say "40,000 character" and `nvarchar(max)` together as if they are equivalent. They are not. Am I misinterpreting? – r2evans Jun 03 '22 at 12:52

0 Answers0