changing field lengths

[jhamill]

we've noticed that in the prospects table, the title field is only 25 characters long, yet in the contact field, it's 50 characters. is it safe to increase the field size in prospects (and will it break anything if we do it)?

john

[kbrill]

we've noticed that in the prospects table, the title field is only 25 characters long, yet in the contact field, it's 50 characters. is it safe to increase the field size in prospects (and will it break anything if we do it)?

john

as long as you change the length in the table and vardefs you should be fine.

[ocaptain]

I'm having a problem with this... I created a custom field in my Contact screen with a length of 25. Worked fine.

I then went into the Custom Field Editor and changed it to 50. When I go into the Contact Edit screen I can still only put in 25 characters. I deleted the field from the form, saved the form, and re-added the field and I can still only enter 25 characters, though the field definition has a Max size of 50.

Any ideas?

Thanks!!!

-Anthony

[paikmoses]

Hi John and Anthony,

You can directly change them through the phpMyAdmin. Simply run this query:

ALTER TABLE `leads_cstm` CHANGE `website_c` `website_c` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'http://'

I did this for my leads custom field and changed the varchar value from 50 to 100. Change the "leads_cstm" to contact custom table name.

Hope this helps.

Regards,