CRM 2011 – How long can a single line of text be?

A customer asked me how long could the Last Name field on a contact be?

an interesting question, even if it wasn’t one I was expecting.

I initially was slightly confused and wondered if the maximum length was words or characters when you are creating a new field.  It’s characters if you are wondering.

The limit is 4000 characters, I can’t imagine anyone with a name that long and you would have to pity someone signing their name if it was over 1000 characters let alone 4000.




3 thoughts on “CRM 2011 – How long can a single line of text be?

  1. Adam Vero October 24, 2011 / 9:48 pm

    The answer is 4000 because SQL won’t allow more than 8,000 bytes* in a single row, so clearly a column is also limited by this and CRM always uses unicode (hence the n in nvarchar) so that’s 2 bytes per character. Hope this helps explain things.

    *actually 8060 but there’s some overhead of things like row headers and so on.


  2. Hosk October 24, 2011 / 10:19 pm

    thanks Adam, I hadn’t thought about the underlying SQL database. It’s always good to have understand the logic behind things


  3. Cathie April 29, 2016 / 4:43 pm

    How do you determine the max length for other fields? Wondering in this instance, about the Other Activities field. Thanks!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s