# How can i keep the fields case sensitive using logstash jdbc

**URL:** <https://discuss.elastic.co/t/how-can-i-keep-the-fields-case-sensitive-using-logstash-jdbc/62957>\
**Category:** Logstash\
**Created:** [October 13, 2016, 2:23pm UTC](https://discuss.elastic.co/t/how-can-i-keep-the-fields-case-sensitive-using-logstash-jdbc/62957 "2016-10-13T14:23:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![saisn](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@saisn](https://discuss.elastic.co/u/saisn)\
**Post date:** [October 13, 2016, 2:23pm UTC](https://discuss.elastic.co/t/how-can-i-keep-the-fields-case-sensitive-using-logstash-jdbc/62957/1 "2016-10-13T14:23:22Z")

</div>

Hi ,

I want the field name to be exactly same when importing from logstash instead of default lowercase conversion

For eg: 'FirstName' field in SQL should be imported exactly as 'FirstName' in elasticsearch not 'firstname'.

---

<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:** [October 18, 2016, 6:01am UTC](https://discuss.elastic.co/t/how-can-i-keep-the-fields-case-sensitive-using-logstash-jdbc/62957/2 "2016-10-18T06:01:04Z")

</div>

I don't think Logstash is doing any downcasing of field names. Please show your configuration files.

---

<div class="post-metadata">

**Author:** ![saisn](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@saisn](https://discuss.elastic.co/u/saisn)\
**Post date:** [October 19, 2016, 5:56pm UTC](https://discuss.elastic.co/t/how-can-i-keep-the-fields-case-sensitive-using-logstash-jdbc/62957/3 "2016-10-19T17:56:11Z")

</div>

input {  
jdbc {  
jdbc\_driver\_library =\> "/opt/logstash-2.3.2/SQLServerDriver/sqljdbc4-3.0.jar"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_connection\_string =\> "jdbc:sqlserver:/xxxxx"  
jdbc\_user =\> "xxxxxxxx"  
jdbc\_password =\> "xxxxxxx"  
jdbc\_page\_size =\> "50000"  
statement\_filepath =\> "sqlqueries/xxx.sql"  
}  
}  
filter {

}  
output {  
elasticsearch {  
hosts =\> ""  
index =\> "xxx"  
document\_type =\> "xxxx"  
document\_id =\>"%{serial}"  
#protocol =\> "http"  
}   
stdout {  
codec =\> rubydebug  
}  
}

---

<div class="post-metadata">

**Author:** ![saisn](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@saisn](https://discuss.elastic.co/u/saisn)\
**Post date:** [October 19, 2016, 6:28pm UTC](https://discuss.elastic.co/t/how-can-i-keep-the-fields-case-sensitive-using-logstash-jdbc/62957/4 "2016-10-19T18:28:11Z")

</div>

I was able to resolve this by adding below parameter in input.

lowercase\_column\_names =\> false

Thanks

---

<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:33am UTC](https://discuss.elastic.co/t/how-can-i-keep-the-fields-case-sensitive-using-logstash-jdbc/62957/5 "2017-07-06T04:33:31Z")

</div>