# CSV output plugin: encoding

**URL:** https://discuss.elastic.co/t/csv-output-plugin-encoding/137384
**Category:** Logstash
**Created:** [June 26, 2018, 8:20am UTC](https://discuss.elastic.co/t/csv-output-plugin-encoding/137384 "2018-06-26T08:20:26Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Jean-Marc\_Autexier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jean-marc_autexier/32/51342_2.png) [@Jean-Marc\_Autexier](https://discuss.elastic.co/u/Jean-Marc_Autexier)
#### Post date: [June 26, 2018, 8:20am UTC](https://discuss.elastic.co/t/csv-output-plugin-encoding/137384/1 "2018-06-26T08:20:26Z")

</div>

Hi,

I'm reading data usign jdbc from a database and writing them into a CSV file using the logstash csv output plugin. The data contains UTF-8 charcaters.  
How can I configure the encoding of the csv fiel to UTF-8?

br,  
Jean-Marc

---

<div class="post-metadata">

### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [June 26, 2018, 8:36am UTC](https://discuss.elastic.co/t/csv-output-plugin-encoding/137384/2 "2018-06-26T08:36:42Z")

</div>

I'd expect that to be the default. What are you getting now?

---

<div class="post-metadata">

### Author: ![Jean-Marc\_Autexier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jean-marc_autexier/32/51342_2.png) [@Jean-Marc\_Autexier](https://discuss.elastic.co/u/Jean-Marc_Autexier)
#### Post date: [June 26, 2018, 9:00am UTC](https://discuss.elastic.co/t/csv-output-plugin-encoding/137384/3 "2018-06-26T09:00:58Z")

</div>

thanks for your quick response.  
Looking at the file, indeed it seems to be utf-8 (but I have to further check it).  
But the file has no BOM, so some tools are confused...

---

<div class="post-metadata">

### Author: ![Jean-Marc\_Autexier](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jean-marc_autexier/32/51342_2.png) [@Jean-Marc\_Autexier](https://discuss.elastic.co/u/Jean-Marc_Autexier)
#### Post date: [June 26, 2018, 9:14am UTC](https://discuss.elastic.co/t/csv-output-plugin-encoding/137384/4 "2018-06-26T09:14:15Z")

</div>

further checking the data, it looks like the problem is a backslash at the end of a string.  
The backslash is not escaped, so it is escaping the quote.

```
String (from a jdbc db): test\
Generated (quoted) string in csv file: "test\" 
The expected quoted string in csv is: "test\\"

```

Updated, to avoid that discuss remove the backslashes

---

<div class="post-metadata">

### Author: ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)
#### Post date: [June 26, 2018, 9:18am UTC](https://discuss.elastic.co/t/csv-output-plugin-encoding/137384/5 "2018-06-26T09:18:08Z")

</div>

That definitely sounds like a bug.

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 24, 2018, 9:18am UTC](https://discuss.elastic.co/t/csv-output-plugin-encoding/137384/6 "2018-07-24T09:18:11Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
