RODBC returns truncated errors

dplyr
shiny
rstudio

#1

I'm trying to query a Redshift database using the odbc package, however when I get the query, it is truncated. I've asked this in StackOverflow: https://stackoverflow.com/questions/50380575/rodbc-returning-truncated-results

If anyone can help, that would be great. I've also tried this tip


#2

When you say the data are truncated, do you mean in RStudio's viewer, or at the console, or both?


#3

Yup the truncation occurs in both the view and the console


#4

That's very odd. Does the truncation persist if you select a single column as vector, e.g. (based on your SO code) data$gender?


#5

Yea it's really odd. It persists inside the dataframe while in the databse the string is complete. I've never encountered this before


#6

Dead weird.

What's the data type in the column (both in the database and in R)?