Dear Wayne,
I had similar problems and as Andrew Ward suggests you can overcome them
by recompiling the RODBC code, which is what I did after Professor
Ripley's kind advice for Windows. I am now able to read in 64K character
strings.
However, as of version 1.0.2 the source code sets a 64K limit, so I
suspect if you install a more recent copy of the library it will work
correctly - the Windows version 1.0.4 works correctly.
Best wishes,
Simon Gibbon
ICI Strategic Technology Group
ICI PLC
Wilton Centre
Redcar
TS10 4RF
Original question form Wayne Jones <[EMAIL PROTECTED]>:
> Hello there fellow R-users,
>
> 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
> 255.
> 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.
> Reagrds
> Wayne
> Dr Wayne R. Jones
> Statistician / Research Analyst
> KSS Group plc
> St James's Buildings
> 79 Oxford Street
> Manchester M1 6SS
[[alternative HTML version deleted]]
______________________________________________
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
