# Elastic search results are in lower case

**URL:** <https://discuss.elastic.co/t/elastic-search-results-are-in-lower-case/932>\
**Category:** Elasticsearch\
**Created:** [May 19, 2015, 8:40pm UTC](https://discuss.elastic.co/t/elastic-search-results-are-in-lower-case/932 "2015-05-19T20:40:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![sriramnageswaran](https://avatars.discourse-cdn.com/v4/letter/s/258eb7/32.png) [@sriramnageswaran](https://discuss.elastic.co/u/sriramnageswaran)\
**Post date:** [May 19, 2015, 8:40pm UTC](https://discuss.elastic.co/t/elastic-search-results-are-in-lower-case/932/1 "2015-05-19T20:40:13Z")

</div>

We are populating Elastic search indices from a SQL data base. The search results are in lower case. We need the right casing with which the data was updated. Is there any setting that will help retain the case of the data being stored?

---

<div class="post-metadata">

**Author:** ![theuntergeek](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/theuntergeek/32/44961_2.png) [@theuntergeek](https://discuss.elastic.co/u/theuntergeek)\
**Post date:** [May 19, 2015, 8:54pm UTC](https://discuss.elastic.co/t/elastic-search-results-are-in-lower-case/932/2 "2015-05-19T20:54:11Z")

</div>

You'll need to do a mapping of some kind with the field(s) set to not\_analyzed. With [multi-field mappings,](https://www.elastic.co/guide/en/elasticsearch/reference/0.90/mapping-multi-field-type.html) you can keep one analyzed and another version of the same data not\_analyzed.

---

<div class="post-metadata">

**Author:** ![theuntergeek](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/theuntergeek/32/44961_2.png) [@theuntergeek](https://discuss.elastic.co/u/theuntergeek)\
**Post date:** [May 19, 2015, 8:55pm UTC](https://discuss.elastic.co/t/elastic-search-results-are-in-lower-case/932/3 "2015-05-19T20:55:28Z")

</div>

Holy cow, I can't believe I linked to 0.90.x documentation!

This is better and current:

[https://www.elastic.co/guide/en/elasticsearch/reference/current/\_multi\_fields.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/_multi_fields.html)

---

<div class="post-metadata">

**Author:** ![theuntergeek](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/theuntergeek/32/44961_2.png) [@theuntergeek](https://discuss.elastic.co/u/theuntergeek)\
**Post date:** [May 19, 2015, 8:59pm UTC](https://discuss.elastic.co/t/elastic-search-results-are-in-lower-case/932/4 "2015-05-19T20:59:35Z")

</div>

And [this](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-core-types.html#_multi_fields_3) is the full reference.

---

<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, 12:13am UTC](https://discuss.elastic.co/t/elastic-search-results-are-in-lower-case/932/5 "2017-07-06T00:13:15Z")

</div>