R help - Jun 2005 - factor to character

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

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