# singleLineTxt in mssql \[Jan 31\]

**URL:** <https://community.nocodb.com/t/singlelinetxt-in-mssql-jan-31/125>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 7:45am UTC](https://community.nocodb.com/t/singlelinetxt-in-mssql-jan-31/125 "2022-11-03T07:45:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:45am UTC](https://community.nocodb.com/t/singlelinetxt-in-mssql-jan-31/125/1 "2022-11-03T07:45:00Z")

</div>

> 🙋‍♂️ **Vidotti** _asked_

## When inserting new SingleLineText columns (MSSQL db) , the field length is empty and database column is set to varchar(1)… I think that the default length value should be 200, to make it easier to get table setup faster… what do you think?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:45am UTC](https://community.nocodb.com/t/singlelinetxt-in-mssql-jan-31/125/2 "2022-11-03T07:45:01Z")

</div>

> 💁 **o1lab** _replied_

#### Issue is created

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 7:45am UTC](https://community.nocodb.com/t/singlelinetxt-in-mssql-jan-31/125/3 "2022-11-03T07:45:02Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/936749593578864640)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)