Logstash JDBC Statement with Unicode

Elastic Stack Logstash
1

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

2

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

3

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.

4

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.

5

locale = en_US
configuration file character set seems to be = windows-1255

6

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.