# What is the equivalent datatype for clob column in elastic search?

**URL:** <https://discuss.elastic.co/t/what-is-the-equivalent-datatype-for-clob-column-in-elastic-search/221658>\
**Category:** Elasticsearch\
**Created:** [March 2, 2020, 10:23am UTC](https://discuss.elastic.co/t/what-is-the-equivalent-datatype-for-clob-column-in-elastic-search/221658 "2020-03-02T10:23:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dgurusam](https://avatars.discourse-cdn.com/v4/letter/d/b19c9b/32.png) [@dgurusam](https://discuss.elastic.co/u/dgurusam)\
**Post date:** [March 2, 2020, 10:23am UTC](https://discuss.elastic.co/t/what-is-the-equivalent-datatype-for-clob-column-in-elastic-search/221658/1 "2020-03-02T10:23:16Z")

</div>

A CLOB (character large object) value can be up to 2,147,483,647 characters long. A CLOB is used to store unicode character-based data, such as large documents in any character set.

What is the equivalent datatype for clob column in elastic search?

As per this link [https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-data-types.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-data-types.html), text data type size is 2,147,483,647.

Can we use text datatype in elasticsearch to store clob columns?

---

<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:** [March 30, 2020, 10:31am UTC](https://discuss.elastic.co/t/what-is-the-equivalent-datatype-for-clob-column-in-elastic-search/221658/2 "2020-03-30T10:31:46Z")

</div>

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