Increasing the size of a custom field

Article Number: 68 | Last Updated: Mon, Apr 9, 2012 at 1:42 AM

By default each custom field in Sitelok can store up to 255 characters. This is fine for most cases but you can if required change the field type to MEDIUMTEXT so that up to 16777215 characters can be stored. To do this login to the Sitelok admin and in the SQL Query field enter the following SQL code

ALTER TABLE `sitelok` CHANGE `Custom3` `Custom3` MEDIUMTEXT

making sure you set the two occurrences of 3 above to the custom field you want to change. Click the Query button to execute it. After you have increased the size of the custom field you will see that a text area field is used in the Add User and Edit User pages of the Sitelok control panel allowing extra data to be entered.

To set a custom field back to the default 255 character limit use the following SQL.

ALTER TABLE `sitelok` CHANGE `Custom3` `Custom3` VARCHAR(255)