Problem with german umlauts in generated CSV file using Grails

Question

Hi,

I have a problem with the german umlauts like ä,ö,ü in generated CSV files using Grails, here is the snippet of my code

def report = {
    //....
    response.setContentType("text/csv; charset=UTF-8");
    response.setHeader("Content-disposition", "attachment; filename=" + params.dateiname + "");   
    response.setCharacterEncoding("UTF-8")   
    response.outputStream << datalist  // in datalist are the data in CSV format like "File";"Date";"Customer" etc.
}

After calling the closure and saving the file the german umlauts are diplayed wrong with Excel, but they are displayed correct when I open the file with notepad.

Does anyone have an idea of this Problem?

Thanks in advance!

mozilla20

Where is the data which contains the Umlauts stored? Is it read from the DB or any other file? — david, Jan 24 '11 at 22:03
the data which contains the Umlauts are retrieved from the MySQL DB. — user587816, Jan 25 '11 at 08:19

score 4 · Accepted Answer · edited May 23 '17 at 11:47

4

IIRC, Excel assumes ANSI CSV encoding. Explicit BOM helps sometimes: Microsoft Excel mangles Diacritics in .csv files?

edited May 23 '17 at 11:47

Community

1
1

answered Jan 26 '11 at 10:47

Victor Sergienko

13,115
3
57
91

Yes, you are right. I added BOM to the file, and it works now. Thank you very much! – user587816 Jan 26 '11 at 11:58

Problem with german umlauts in generated CSV file using Grails

1 Answers1

Linked