How to increase lenght of characters in dbGetQuery?

Hi together

This is my first post here. I am having an issue with limited character length when using dbGetQuery. I connect to my database and table using the command below:

db_connection <- dbConnect(odbc::odbc(), "MyDatabase", timeout = 10)
table <- dbGetQuery(conn = db_connection, statement = "select * from MyTable")

One field (called forecast) of the table contains strings which typically are more than 1000 characters long. When I check this field for the first entry in the table:


I get returned 126 characters. Is there a way to increase this limit so that I have access to the full string? Thank you for your suggestions.

Kind regards

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.