Maximum field length

Is there a supported way to extend the field length of existing MS CRM fields?
In our backend the field corresponding with address street1 is 60 chars long.
As we we want to avoid losing data, I was wondering if the length of standard
MS CRM fields can be changed to a higher number than currently set.

Regards.

Michael
Thu Mar 29 11:28:25 CDT 2007

There's no supported way to do it. You can only make the field size smaller.

--
Michael Höhne, Microsoft Dynamics CRM MVP

Web: http://www.stunnware.com/crm2
Feed: http://www.stunnware.com/crm2/atom.aspx
Custom Lookup Dialog: http://www.stunnware.com/crm2/?area=customLookup

----------------------------------------------------------

"GM" <me@google.com> schrieb im Newsbeitrag
news:bac512c655c98c9404505007c99@news.microsoft.com...
> Is there a supported way to extend the field length of existing MS CRM
> fields?
> In our backend the field corresponding with address street1 is 60 chars
> long. As we we want to avoid losing data, I was wondering if the length of
> standard MS CRM fields can be changed to a higher number than currently
> set.
>
> Regards.
>
>

Andy
Thu Mar 29 14:59:54 CDT 2007

And you may want to consider that 48 characters is usually the longest
text string that can appear in a windowed paper envelope, so you
should try to break your address across the four address lines instead
of cramming it all into one line JUST to maintain this compatability
for CRM printed paper documents.

You can go into the SQL Server organizationName_MSCRM database and
change the field lengths in the internaladdressbase table address
fields 1 through 4 (which are set to 50 characters for CRM 3.0). But,
you will have to remember to do this again everytime you upgrade or
reinstall CRM, so its not a reccomended change.