<div dir="ltr">In Vtiger 6.1.0 length of the comment field is set to 500.Its the same in the migrated instance.<div>Let me know me if have missed something here.I have posted the mysql describe results.<br><div><br></div><div>
mysql results:<br><div><br></div><div><div>mysql> desc vtiger_inventoryproductrel;</div><div>+------------------+---------------+------+-----+---------+----------------+</div><div>| Field            | Type          | Null | Key | Default | Extra          |</div>
<div>+------------------+---------------+------+-----+---------+----------------+</div><div>| id               | int(19)       | YES  | MUL | NULL    |                |</div><div>| productid        | int(19)       | YES  | MUL | NULL    |                |</div>
<div>| sequence_no      | int(4)        | YES  |     | NULL    |                |</div><div>| quantity         | decimal(25,3) | YES  |     | NULL    |                |</div><div>| listprice        | decimal(27,8) | YES  |     | NULL    |                |</div>
<div>| discount_percent | decimal(7,3)  | YES  |     | NULL    |                |</div><div>| discount_amount  | decimal(27,8) | YES  |     | NULL    |                |</div><div>| comment          | varchar(500)  | YES  |     | NULL    |                |</div>
<div>| description      | text          | YES  |     | NULL    |                |</div><div>| incrementondel   | int(11)       | NO   |     | 0       |                |</div><div>| lineitem_id      | int(11)       | NO   | PRI | NULL    | auto_increment |</div>
<div>| tax1             | decimal(7,3)  | YES  |     | NULL    |                |</div><div>| tax2             | decimal(7,3)  | YES  |     | NULL    |                |</div><div>| tax3             | decimal(7,3)  | YES  |     | NULL    |                |</div>
<div>+------------------+---------------+------+-----+---------+----------------+</div><div>14 rows in set (0.04 sec)</div><div><br></div><div>mysql> use vtigercrm540;</div><div>Reading table information for completion of table and column names</div>
<div>You can turn off this feature to get a quicker startup with -A</div><div><br></div><div>Database changed</div><div>mysql> desc vtiger_inventoryproductrel;</div><div>+------------------+---------------+------+-----+---------+----------------+</div>
<div>| Field            | Type          | Null | Key | Default | Extra          |</div><div>+------------------+---------------+------+-----+---------+----------------+</div><div>| id               | int(19)       | YES  | MUL | NULL    |                |</div>
<div>| productid        | int(19)       | YES  | MUL | NULL    |                |</div><div>| sequence_no      | int(4)        | YES  |     | NULL    |                |</div><div>| quantity         | decimal(25,3) | YES  |     | NULL    |                |</div>
<div>| listprice        | decimal(27,8) | YES  |     | NULL    |                |</div><div>| discount_percent | decimal(7,3)  | YES  |     | NULL    |                |</div><div>| discount_amount  | decimal(27,8) | YES  |     | NULL    |                |</div>
<div>| comment          | varchar(500)  | YES  |     | NULL    |                |</div><div>| description      | text          | YES  |     | NULL    |                |</div><div>| incrementondel   | int(11)       | NO   |     | 0       |                |</div>
<div>| lineitem_id      | int(11)       | NO   | PRI | NULL    | auto_increment |</div><div>| tax1             | decimal(7,3)  | YES  |     | NULL    |                |</div><div>| tax2             | decimal(7,3)  | YES  |     | NULL    |                |</div>
<div>| tax3             | decimal(7,3)  | YES  |     | NULL    |                |</div><div>+------------------+---------------+------+-----+---------+----------------+</div><div>14 rows in set (0.00 sec)</div></div><div>
<br></div></div></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Jun 10, 2014 at 7:39 PM, micker <span dir="ltr"><<a href="mailto:micker@free.fr" target="_blank">micker@free.fr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">hello i used vtiger 5.4 and use comment field to describ more my invoice<br>
now in vtiger 6.0 this field is limited to 250 caratere ..<br>
why this regression ?<br>
Regards<br>
<br>
<br>
<br>
--<br>
View this message in context: <a href="http://vtiger-crm.2324883.n4.nabble.com/why-inventoryproductrel-change-to-varchar-tp10920.html" target="_blank">http://vtiger-crm.2324883.n4.nabble.com/why-inventoryproductrel-change-to-varchar-tp10920.html</a><br>

Sent from the vtigercrm-developers mailing list archive at Nabble.com.<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div><br></div>