[R]: RODBC column length>255

[Andrew C. Ward]

Dear Wayne,

This could be related to the ODBC specification, and so you
won't be able to change it. If it's hard-coded into RODBC, 
you will be able to modify the code and recompile the 
package yourself.

Alternatively, there may be another package that reads your
data without going through ODBC. I believe there are some
for Oracle, MySQL and others.


Regards,

Andrew C. Ward

CAPE Centre
Department of Chemical Engineering
The University of Queensland
Brisbane Qld 4072 Australia
andreww at cheque.uq.edu.au


Quoting Wayne Jones <JonesW at 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
> 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 at kssg.com		http://www.kssg.com
> 
> 
> The information in this Internet email is confidential
> and m...{{dropped}}
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://www.stat.math.ethz.ch/mailman/listinfo/r-help
>