Thanks for your answer. I went round the problem by directly connect to the sql-database instead of generating a .csv file and then upload it. This works perfectly with the RODBC package and is much more suitable, too.
Kind regards Christian Prof Brian Ripley schrieb: > On Fri, 6 Oct 2006, Christian Bieli wrote: > >> Hi all >> >> I have to generate some test data for import in an sql database. The >> database is meant for web-based data entry in a study taking place in a >> german speaking region, so factor levels of the variables include >> umlauts. >> The variables in the dataframe t.muster are generated e.g. like this: >> >> t.muster$screening <- rep("ausgefüllt",50) >> >> and exported to a .csv file by: >> >> write.table(t.muster,"MakeMuster041006/MusterDaten.csv", >> col.names=FALSE,row.names=FALSE,na="",sep=";") >> >> After export the factor level including an umlaut of t.muster$screening >> look like this in the sql-database as well as in an excel spreadsheet: >> >> ausgefüllt > > I think the problem is rather how you imported them. That is the > UTF-8 representation of the "ausgefüllt" viewed in a single-byte > locale. R on Windows does not handle UTF-8, so something else has > done the conversion. > > [...] > ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.