[R] adding slashes in sql querys
Prof Brian Ripley
ripley at stats.ox.ac.uk
Sun Apr 1 09:39:23 CEST 2007
I think this is about RODBC, uncredited.
There is currently no way to do escapes here, and I am pretty sure that
ODBC drivers do not support 'slash' as an escape (or did you mean
backslash? I am still not sure that would work).
sqlSave() has fast=TRUE and fast=FALSE options, and it is worth trying
both. Since the default fast=TRUE passes character data as binary fields,
I don't understand why there is a problem (there might be for fast=FALSE
with single quotes in character fields).
Without any relevant details (OS, R version, packages used, package
version, ODBC driver, DBMS) and any sort of example it is really hard to
offer help: please DO study the R posting guide (and note also the comment
about using a signature block).
On Sat, 31 Mar 2007, Laurent Valdes wrote:
> Hi everybody,
> I'm doing a sqlSave() in R, to insert a big data frame of 10000 rows.
> However, there is problems, since several rows contains quotations marks,
> that can leave inserts buggy.
> I would like to find a way to add slashes in front of these quotation marks.
> Best regards,
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