Increasing Length of Comments Field

(0) Share

Report

Posted on by Matthew Wylie

225

Is there any good reason not to increase the comments fields (particularly in areas which will not directly be posted areas, such as contacts [comments table = 5061] and jobs [comment table = 97]) above the basic 80 characters? In researching this, the only reason that I have seen is to have backward compatibility with ancient versions of a pre-SQL Navision database.

Thanks.

*This post is locked for comments

All responses (4)

Answers (1)

mmv 11,467 on at

Like (0)

Report

RE: Increasing Length of Comments Field

Hi,

As mentioned by others, it may have a huge impact and may give overflow error. Increasing the length doesn't seem to be a wise decision because tomorrow, if the new size is insufficient, you may have to increase it again and will lead to square one.

Best Regards,

MMV
Suggested answer

Tharanga Chandrasekara 23,116 on at

Like (0)

Report

RE: Increasing Length of Comments Field

As Mohana said you can use multiple lines for comments any any special reason for doing this?

Modifying comment is not a huge impact, but you need to modify all the other locations as well. It will take some time and effort and my suggestion is to use multiple lines without doing any modifications.
Verified answer

Mohana Yadav 60,228 Super User 2025 Season 1 on at

Like (0)

Report

RE: Increasing Length of Comments Field

You can use multiple lines in comments then why do you want to increment?
Suggested answer

keoma 32,727 on at

Like (0)

Report

RE: Increasing Length of Comments Field

hi,

increasing text fields can cause problems. you can only give it a try with a test database. a good idea is to run a "where used"-function (e.g. OM-Tools from idyn.net) to check, where the field is used (functions, ...).