1

I use the ODBC package to connect to a Sybase IQ database. There are location names in one column as a varchar and when I use the command dbGetQuery(con, statement), I only get the names as partial results i.e. "Manhattan, New York" becomes "Manhattan, New Yo". How to solve this issue?

minimalbob
  • 51
  • 4
  • Does this answer your question? [RODBC string getting truncated](https://stackoverflow.com/questions/4623460/rodbc-string-getting-truncated) – mnist Oct 11 '22 at 09:03
  • no, because I have a JDBC connection and I can't change those values in windows in such a manner (PS: I'm sort of a noob in server stuff) – minimalbob Oct 11 '22 at 09:43
  • how do you define your connection? – mnist Oct 11 '22 at 09:44
  • drv <- JDBC("com.sybase.jdbc4.jdbc.SybDriver", "*/jconn4.jar") conn <- dbConnect(drv, URL, "user", "password") – minimalbob Oct 11 '22 at 09:46
  • and setting the parameter `MaxLongVarcharSize` does not work? Is not possible? – mnist Oct 11 '22 at 09:49
  • No, I've added that and made it conn <- RJDBC::dbConnect(drv, URL, "user", "password", MaxLongVarcharSize=256000) but it still truncates strings in such a fashion – minimalbob Oct 11 '22 at 09:51
  • Let us [continue this discussion in chat](https://chat.stackoverflow.com/rooms/248727/discussion-between-minimalbob-and-mnist). – minimalbob Oct 11 '22 at 09:55

0 Answers0