-2

Ik building an GO application where I want to output a cvs string from a buffer out via the http server.

I'm putting it into the csv buffer:

var buffer bytes.Buffer
resp := csv.NewWriter(&buffer)
resp.Write("Schröder")

The output it via the http server:

resp.Flush()
w.Header().Set("Content-Type", "text/csv; charset=utf-8")
w.Write([]byte(buffer.String()))

When I then open my url a csv file is download en opened by Excel. In that excelsheet the field value is converted to "Schröder".

Any idee, i'm already a week stuk on this item?

Steffen Ullrich
  • 114,247
  • 10
  • 131
  • 172
Tom
  • 1,547
  • 7
  • 27
  • 50
  • please edit your question to show output (as text, not images) of `show create table yourtablename;` and `select version();` – ysth Feb 10 '22 at 20:27
  • I removed the database part as with an hardcode string I'm getting the same wrong results – Tom Feb 10 '22 at 20:35

1 Answers1

2

The problem is not in Go but in Excel. The information that the data are encoded in UTF-8 is lost when saving the file, since there is no such thing as an encoding attribute on saved files.

Thus Excel will just see the plan data and has no information about the encoding. There are several tricks to make Excel do the right guess, like placing the proper byte order mark (BOM) at start of the file. See Is it possible to force Excel recognize UTF-8 CSV files automatically?. But just specifying charset=utf-8 within the HTTP Content-type header will not help since Excel does not get this information.

Steffen Ullrich
  • 114,247
  • 10
  • 131
  • 172