# Large Multi Select Field

**URL:** <https://forum.mautic.org/t/large-multi-select-field/10840>\
**Category:** General Discussion\
**Created:** [July 10, 2019, 4:55pm UTC](https://forum.mautic.org/t/large-multi-select-field/10840 "2019-07-10T16:55:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pstevens](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/pstevens/32/237_2.png) [@pstevens](https://forum.mautic.org/u/pstevens)\
**Post date:** [July 10, 2019, 4:55pm UTC](https://forum.mautic.org/t/large-multi-select-field/10840/1 "2019-07-10T16:55:43Z")

</div>

Hey I’ve got a multi-select field that may have a large amount of data if many of the options are selected. The problem I’m running into is Multi-Select fields are stored as VARCHAR(255) in the database with a maximum of 255 characters. Is it better to change the VARCHAR field to like 2000 characters in the database? OR Is it better to change the field type in the database to TEXT?

Anyone run into this?

---

<div class="post-metadata">

**Author:** ![silavapi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/silavapi/32/7424_2.png) [@silavapi](https://forum.mautic.org/u/silavapi)\
**Post date:** [January 25, 2021, 8:53pm UTC](https://forum.mautic.org/t/large-multi-select-field/10840/2 "2021-01-25T20:53:00Z")

</div>