[R] factor to character

Prof Brian Ripley ripley at stats.ox.ac.uk
Tue Jun 28 18:38:03 CEST 2005


On Tue, 28 Jun 2005, Omar Lakkis wrote:

> Using RODBC, when I select from a table strings (chars and varchars)
> come as factors. What is the best way, speed wise, to convert these
> columns back to strings (perhaps using as.character).

FAQ Q7.10, replacing "numeric" by "character".

You do have control in RODBC, in fact: see ?sqlFetch.

-- 
Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595




More information about the R-help mailing list