# Logstash JDBC Statement with Unicode

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412>\
**Category:** Logstash\
**Created:** [August 31, 2016, 10:33am UTC](https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412 "2016-08-31T10:33:12Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![yaacovki](https://avatars.discourse-cdn.com/v4/letter/y/8c91f0/32.png) [@yaacovki](https://discuss.elastic.co/u/yaacovki)\
**Post date:** [August 31, 2016, 10:33am UTC](https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412/1 "2016-08-31T10:33:12Z")

</div>

Hi,

I'm trying to Run an Oracle SQL Statement with JDBC.  
the SQL Statement has some unicode text in it (Hebrew) in order to filter information.

Logstash cannot run this.

this is a basic example that isnt working neither:  
select 'אאאא' A from dual

Error: invalid byte sequence in UTF-8

Can i change the encoding used by logstash ?

BR,  
Yaacov

---

<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:** [September 4, 2016, 7:49pm UTC](https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412/2 "2016-09-04T19:49:48Z")

</div>

What locale are you using (run `locale`)? What's the character encoding of your configuration file?

---

<div class="post-metadata">

**Author:** ![yaacovki](https://avatars.discourse-cdn.com/v4/letter/y/8c91f0/32.png) [@yaacovki](https://discuss.elastic.co/u/yaacovki)\
**Post date:** [September 5, 2016, 4:11am UTC](https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412/3 "2016-09-05T04:11:59Z")

</div>

configuration file is ANSI  
Sql file referred in configuration file is ANSI too.

Where can i find the locale settings?  
i didn't define it in configuration file.

---

<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:** [September 5, 2016, 5:46am UTC](https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412/4 "2016-09-05T05:46:38Z")

</div>

> configuration file is ANSI  
> Sql file referred in configuration file is ANSI too.

ANSI can mean a lot of things but it's not a Unicode encoding. In other words my previous question remains.

> Where can i find the locale settings?

As I said, run `locale`.

It could very well be that Logstash assumes that you're using UTF-8.

---

<div class="post-metadata">

**Author:** ![yaacovki](https://avatars.discourse-cdn.com/v4/letter/y/8c91f0/32.png) [@yaacovki](https://discuss.elastic.co/u/yaacovki)\
**Post date:** [September 14, 2016, 5:06am UTC](https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412/5 "2016-09-14T05:06:55Z")

</div>

locale = en\_US  
configuration file character set seems to be = windows-1255

---

<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:** [September 14, 2016, 5:34am UTC](https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412/6 "2016-09-14T05:34:52Z")

</div>

Well, the simplest way out would be to simply use UTF-8 in the configuration file. I don't know of any way to configure which character set or encoding Logstash expects files to be in.

---

<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 6, 2017, 4:38am UTC](https://discuss.elastic.co/t/logstash-jdbc-statement-with-unicode/59412/7 "2017-07-06T04:38:37Z")

</div>