How to increase lenght of characters in dbGetQuery?

General
1

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:

library(DBI)
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:

nchar(table$forecast[1])
126

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
Benjamin

2

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.