Displaying 1 result from an estimated 1 matches for "ga1prosp".
2012 Mar 30
0
RMySQL and german umlaute
Hi list,
I have some trouble to setup RMySQL correctly to work with german umlaute:
> library(RMySQL)
Loading required package: DBI
> pg <- dbDriver("MySQL")
> con <- dbConnect(pg, username="dummy", host="localhost", password="",
dbname="ga1prosp")
> dbGetQuery(con, statement="SELECT * FROM K?rperma?e;")
Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver:
(could not run statement: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use...