Is it possible to increase the length of supplier name?

[cinnamon]

i have been searching this for hours and all i can see is about supplier reference. Is it possible to change the length of supplier name? I always get this error every time i try to import csv. Hope you can help me with this problem.

[vekia]

what prestashop version ? (exact number) ?

[cinnamon]

im using 1.5.6.2

i want to change it to 512

Edited November 6, 2014 by cinnamon (see edit history)

[vekia]

1)

 

• go to file: /classes/Supplier.php
• there is a code:

'name' => array('type' => self::TYPE_STRING, 'validate' => 'isCatalogName', 'required' => true, 'size' => 64),

• change it to:

'name' => array('type' => self::TYPE_STRING, 'validate' => 'isCatalogName', 'required' => true, 'size' => 512),

2)

• open database manager software like phpmyadmin,
• then go to ps_supplier table.
• change datatype of name filed (by default: VARCHAR 64)
• change datatype of name field to TEXT (ATTENTION, READ INFORMATIONS BELOW)

 

second step is necessary, 

The length of VARCHAR datatype can be specified as a value from 0 to 255 before MySQL 5.0.3, and 0 to 65,535 in 5.0.3 and later versions

 

so if you use v5.0.3+  of mysql, change varchar to 512, if you use older mysql, change varchar datatype to text

[cinnamon]

i tried it this morning and it works! Thank you sooooo much!