# Not able to pull arabic data by using JDBC input

**URL:** <https://discuss.elastic.co/t/not-able-to-pull-arabic-data-by-using-jdbc-input/80902>\
**Category:** Logstash\
**Created:** [April 1, 2017, 6:32pm UTC](https://discuss.elastic.co/t/not-able-to-pull-arabic-data-by-using-jdbc-input/80902 "2017-04-01T18:32:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dan](https://avatars.discourse-cdn.com/v4/letter/d/eada6e/32.png) [@Dan](https://discuss.elastic.co/u/Dan)\
**Post date:** [April 1, 2017, 6:32pm UTC](https://discuss.elastic.co/t/not-able-to-pull-arabic-data-by-using-jdbc-input/80902/1 "2017-04-01T18:32:53Z")

</div>

I have stored arabic language in my my sql DB.

I am using JDBC input and elasticsearch out put in logstash.  
But my jdbc input not bringing arabic language, Insted its pulling ????????(question Marks).

Please help me how can i pull arabic language using jdbc input.

Below is my config file.

input {  
jdbc {  
jdbc\_driver\_library =\> "logstashhome\mysql-connector-java-5.1.35-bin.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_connection\_string =\> "jdbc:mysql://localhost:9191/dbname"  
jdbc\_user =\> "test"  
jdbc\_password =\> "test"  
statement =\> "select language from testtable"  
schedule =\> "\* \* \* \* \* "  
jdbc\_paging\_enabled =\> "true"  
jdbc\_page\_size =\> "50000"  
}  
}

output {  
stdout { codec =\> rubydebug }  
elasticsearch {  
action =\> "index"  
hosts =\> "127.0.0.1:9200"   
index =\> "testindex"  
workers =\> 1

```
}

```

}

Thanks in Advance........

---

<div class="post-metadata">

**Author:** ![pierhugues](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/pierhugues/32/48383_2.png) [@pierhugues](https://discuss.elastic.co/u/pierhugues)\
**Post date:** [April 7, 2017, 1:37pm UTC](https://discuss.elastic.co/t/not-able-to-pull-arabic-data-by-using-jdbc-input/80902/2 "2017-04-07T13:37:00Z")

</div>

Hello Dan,

Do you know what charset your MySQL columns are using? By default, the JDBC input will assume it's utf-8. If I remember correctly, you can use `SHOW FULL COLUMNS FROM mytable` to get that information.

With that information you can configure the input with `charset` or columns `charset`, there is more details at [https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-charset](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-charset)

---

<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:** [May 5, 2017, 1:43pm UTC](https://discuss.elastic.co/t/not-able-to-pull-arabic-data-by-using-jdbc-input/80902/3 "2017-05-05T13:43:10Z")

</div>

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