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 <JonesW@kssg.com>:

> 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]]


