Hudge description in SO, PO, Q, I module ~"discussion"

If the Clients need write hudge description in SO, PO, Q, I module, there are limited on vtiger_inventoryproductrel.comment field, because it's a VARCHAR.

This SQL can fix this isseu: ALTER TABLE vtiger_inventoryproductrel CHANGE comment comment TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL

Title changed from Hudge description in SO, PO, Q, I module to Hudge description in SO, PO, Q, I module~enhancement

Title changed from Hudge description in SO, PO, Q, I module~enhancement to **Hudge description in SO, PO, Q, I module enhancement **

Title changed from **Hudge description in SO, PO, Q, I module enhancement ** to Hudge description in SO, PO, Q, I module ~"enhancement discussion"

Title changed from Hudge description in SO, PO, Q, I module ~"enhancement discussion" to Hudge description in SO, PO, Q, I module ~"enhancement discussions"

Title changed from Hudge description in SO, PO, Q, I module ~"enhancement discussions" to Hudge description in SO, PO, Q, I module discussion

I would like to see this one implemented too.

To get better understanding, is it possible to share some use-case or business domain that would demand such. A sample SO,PO,Q would be of helpful.

Product/Service module allows you write hudge description. https://demo.vtiger.com/index.php?module=Products&view=Detail&record=221 But if you create a SO,PO,I,Q this description is cut, because of VARCHAR(255) field structure. https://demo.vtiger.com/index.php?module=Invoice&view=Detail&record=222 You really don'ty know about this limitation ? This was reported 100x last 8 year.

Letting huge description in line-item opens trouble at other places - like PDF creation etc... and also a performance concern - so it has not made it to core yet. This can be achieved with simple DB change based on the customization need.

Yeah, can you do this simple DB change in installation script ?

@its4you - I agree the DB change in simple. Addressing the challenge it would bring in with other functionality and performance is not clear - hence would take a while.

In case, you have progressed with the change and validated with sizeable content - please list the areas where it works and breaks. This would be helpful.

It's only on you if you will fix all this kind of issue. There are many many more article in discussion: https://discussions.vtiger.com/index.php?p=/discussion/30656/increasing-characters-in-product-description/p1 https://discussions.vtiger.com/index.php?p=/discussion/21261/lenght-of-product-description-fields/p1 https://discussions.vtiger.com/index.php?p=/discussion/15436/quotes-how-to-add-product-description-information/p1 https://discussions.vtiger.com/index.php?p=/discussion/43727/product-description-cut-in-quotes-modules/p1 https://discussions.vtiger.com/index.php?p=/discussion/168955/-solved-limitation-in-description-products-in-quotes-and-invoices/p1

thanks for the links.

Fixed d3aa4a3b + 6705ece4

Status changed to closed

Milestone changed to 6.5.0

mentioned in issue #1731 (closed)

mentioned in issue #1731 (closed)