RODBC returns truncated errors



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:

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


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


Yup the truncation occurs in both the view and the console


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?


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


Dead weird.

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