R help - Sep 2003 - : RODBC column length>255

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
Tel: +44(0)161 609 4084
Mob: +44(0)7810 523 713




KSS Ltd
Seventh Floor  St James's Buildings  79 Oxford Street  Manchester  M1 6SS 
England
Company Registration Number 2800886
Tel: +44 (0) 161 228 0040	Fax: +44 (0) 161 236 6305
mailto:kssg@kssg.com		http://www.kssg.com


The information in this Internet email is confidential and m...{{dropped}}

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

Hth, Dirk

-- 
Those are my principles, and if you don't like them... well, I have others.
                                                -- Groucho Marx

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
Tel: +44(0)161 609 4084
Mob: +44(0)7810 523 713




KSS Ltd
Seventh Floor  St James's Buildings  79 Oxford Street  Manchester  M1 6SS 
England
Company Registration Number 2800886
Tel: +44 (0) 161 228 0040	Fax: +44 (0) 161 236 6305
mailto:kssg@kssg.com		http://www.kssg.com


The information in this Internet email is confidential and m...{{dropped}}

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