# Why the mysql fields convert to lowercase

**URL:** <https://discuss.elastic.co/t/why-the-mysql-fields-convert-to-lowercase/152966>\
**Category:** Logstash\
**Created:** [October 18, 2018, 9:05am UTC](https://discuss.elastic.co/t/why-the-mysql-fields-convert-to-lowercase/152966 "2018-10-18T09:05:51Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![shinesllw](https://avatars.discourse-cdn.com/v4/letter/s/a587f6/32.png) [@shinesllw](https://discuss.elastic.co/u/shinesllw)\
**Post date:** [October 18, 2018, 9:05am UTC](https://discuss.elastic.co/t/why-the-mysql-fields-convert-to-lowercase/152966/1 "2018-10-18T09:05:51Z")

</div>

I tried to use logstash to deliver the data from mysql to elasticsearch. but when i run the jdbc.conf, i found that all the fields in mysql were converted to lowsecase which exactly was not my hope. Can someone help me to fix it? below is part of the file:

jdbc\_driver\_library =\> "E:/ELK/sqltoes/mysql-connector-java-5.1.42.jar"

# the name of the driver class for mysql

jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
#jdbc\_paging\_enabled =\> "true"  
#jdbc\_page\_size =\> "50000"  
#以下对应着要执行的sql的绝对路径。

# statement\_filepath =\> "/usr/local/logstash-5.6.3/test\_mysql/jdbc.sql"

statement =\> "SELECT \* from test\_collection "  
#定时字段 各字段含义（由左至右）分、时、天、月、年，全部为\*默认含义为每分钟都更新

# schedule =\> "\* \* \* \* \*"

connection\_retry\_attempts =\> 3  
connection\_retry\_attempts\_wait\_time =\> 1

---

<div class="post-metadata">

**Author:** ![Jenni](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jenni/32/29684_2.png) [@Jenni](https://discuss.elastic.co/u/Jenni)\
**Post date:** [October 18, 2018, 9:16am UTC](https://discuss.elastic.co/t/why-the-mysql-fields-convert-to-lowercase/152966/2 "2018-10-18T09:16:37Z")

</div>

This should help, I guess: [lowercase\_column\_names =\> false](https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#plugins-inputs-jdbc-lowercase_column_names)

---

<div class="post-metadata">

**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\
**Post date:** [October 25, 2018, 12:34pm UTC](https://discuss.elastic.co/t/why-the-mysql-fields-convert-to-lowercase/152966/3 "2018-10-25T12:34:52Z")

</div>

check this input code,

input {

jdbc {  
jdbc\_driver\_library =\> "C:/Users/xxxx/Downloads/mysql-connector-java-5.1.42.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_connection\_string =\> "jdbc:mysql://localhost:3306/test"  
jdbc\_user =\> "root"  
jdbc\_password =\> "root"  
statement =\> "SELECT \* FROM SAMPLE"  
jdbc\_paging\_enabled =\> "true"  
jdbc\_page\_size =\> "50000"  
}

}

---

<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:** [November 22, 2018, 12:34pm UTC](https://discuss.elastic.co/t/why-the-mysql-fields-convert-to-lowercase/152966/4 "2018-11-22T12:34:56Z")

</div>

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