Field and Row size changes coming to the Spring 2019 Release

Another change coming to the April 2019 release of Business Central is changes to the field sizes allowed in the code and database.

Fields and variables of type Text and code can now be up to 2048 characters. The same for Text constants.

The earlier restrictions were 250 characters for table fields of type code and text and 1024 for variables of type Code and Text.

Yes I know you could have a Text variable with no length specified that would be unlimited, but this is only a variable and managed differently.

You can find all public information about this here: https://docs.microsoft.com/en-us/business-applications-release-notes/April19/dynamics365-business-central/max-length-of-variable-length-table-fields-has-been-expanded

This comes with another change to the tables where the 8KB row size is getting relaxed. Microsoft has not said a lot about this change and the only public available documentation on this can be found here: https://docs.microsoft.com/en-us/business-applications-release-notes/April19/dynamics365-business-central/relax-requirement-of-8k-row-size

With great power comes a great responsibility:

Just because you can doesn’t mean you should.

We have seen it all too often that restrictions are relaxed and people jump on the wave starting to do all kind of strange things. Use your new found power with great wisdom my friends.

Happy Coding everyone.

3 thoughts on “Field and Row size changes coming to the Spring 2019 Release

  1. Pingback: Microsoft Dynamics 365 Business Central – 2019 Spring Release – waldo's blog

  2. Pingback: Microsoft Dynamics 365 Business Central – 2019 Spring Release - Waldo's Blog - Microsoft Dynamics NAV - Dynamics 365 Business Central/NAV User Group - Dynamics User Group

  3. Pingback: Microsoft Dynamics 365 Business Central – 2019 Spring Release - Microsoft Dynamics NAV Community

Leave a Reply

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

WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.