[R]: RODBC column length>255
edd at debian.org
Thu Sep 4 18:39:35 CEST 2003
On Thu, Sep 04, 2003 at 04:10:12PM +0100, Wayne Jones wrote:
> I am using the RODBC functionality to query a database. I am trying to read
> in a columns of strings which have a character field lengths greater than
> The data.frame that I recieve back from the RODBC query only contains the
> first 255 characters (the rest having been truncated).
> Any help on how to solve this problem would be greatly appreciated.
You may get lucky by simply upgrading your RODBC package. I had the same
problem, wrote a crude patch, sent it to Brian Ripley who then replaced it
with something much better. As usual :)
That was around RODBC_1.0-1, current is 1.0-4. Give it a try. Works for me
with text of up to 8 or 9k stored in a single column.
Those are my principles, and if you don't like them... well, I have others.
-- Groucho Marx
More information about the R-help