12. Extending character limit for description field in opportunities

Question

What is the length of the description field in opportunities and can I increase it?

Answer

The default length of the description field in the opportunities is 16,777,215 characters, as it is a medium text field and it is good enough for the normal usage

Check the following video to see the visual representation of how many characters a description field in opportunities can hold

3MB

video12.mp4

Still if you want to increase its length, that can also be done using the following

ALTER TABLE vtiger_crmentity MODIFY COLUMN description longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL ; query

Using the query the length of the description field in the opportunities can be increased to 4,294,967,295 characters