# Define String Column Length in SDK

**URL:** <https://forum.inductiveautomation.com/t/define-string-column-length-in-sdk/27569>\
**Category:** Module Development\
**Tags:** sdk, database, ignition80\
**Created:** [August 19, 2019, 3:20pm UTC](https://forum.inductiveautomation.com/t/define-string-column-length-in-sdk/27569 "2019-08-19T15:20:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![cody.tamaki](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\
**Post date:** [August 19, 2019, 3:20pm UTC](https://forum.inductiveautomation.com/t/define-string-column-length-in-sdk/27569/1 "2019-08-19T15:20:34Z")

</div>

I’ve got a module that automatically creates a table in SQL and I would like to make a column that would be equivalent to a LONGTEXT in MySQL. What is the best way to define that?

I’m following the guide below.  
[[https://docs.inductiveautomation.com/display/SE/Working+with+Platform+Services](https://docs.inductiveautomation.com/display/SE/Working+with+Platform+Services)]

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [August 19, 2019, 3:25pm UTC](https://forum.inductiveautomation.com/t/define-string-column-length-in-sdk/27569/2 "2019-08-19T15:25:46Z")

</div>

Use `DataType.Text`, rather than `DataType.String` when adding the column to `DBTableSchema`, and the default translator should automatically coerce to whatever the translator defines a ‘long text’ column as (`nvarchar(max)`, `text()`, etc)

---

<div class="post-metadata">

**Author:** ![cody.tamaki](https://avatars.discourse-cdn.com/v4/letter/c/b487fb/32.png) [@cody.tamaki](https://forum.inductiveautomation.com/u/cody.tamaki)\
**Post date:** [August 19, 2019, 3:27pm UTC](https://forum.inductiveautomation.com/t/define-string-column-length-in-sdk/27569/3 "2019-08-19T15:27:05Z")

</div>

Thanks Paul - I’m not sure how I missed that…
