[Vtigercrm-developers] newlines in Product/Service Descriptions

[Prasad]

Alan,

TEXT adds load compared to VARCHAR.
More number of characters can trouble the PDF generation as well.

I feel it should be handled case-to-case basis.

Regards,
Prasad

*Connect with us on: *Twitter <http://twitter.com/vtigercrm> *I*
Facebook<http://www.facebook.com/pages/vtiger/226866697333578?sk=wall>
 *I* Blog <https://blogs.vtiger.com/>* I*
Wiki<http://wiki.vtiger.com/index.php/Main_Page>
 *I *Forums  <https://discussions.vtiger.com>*I*
Website<https://www.vtiger.com/>


On Fri, Nov 29, 2013 at 5:58 PM, Alan Lord <alanslists at gmail.com> wrote:

> Sometimes I am amazed by the kind of things I find... This is in vtiger
> 5.4.0.
>
> Our client wants the newlines that are in many of his Product Description
> field values to be printed in his PDFMaker Quotes, Sales Orders and
> Invoices.
>
> Not an unfair request I think. In fact I was rather surprised to find they
> didn't.
>
> During my investigations I have discovered two rather odd things about
> this area.
>
> 1. The Product/Service Description gets copied to the 'comment' field in
> the vtiger_inventoryproductrel table. The comment field is a VARCHAR of
> *just* 250 chars.
>
> So I fixed that and made it a TEXT.
>
> 2. Even though the data is stored in the comment field with line breaks,
> when you view your Quote in DetailView these are removed and seemingly also
> removed during delivery to PDFMaker. Look at your Quote in EditView
> however, and you can see the line breaks.
>
> I have 2 questions...
>
> 1. How on earth has this managed to be like this for so long?
> 2. What's the right/best way to fix it?
>
> Cheers
>
> Al
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20131129/3ba7750b/attachment.html>