> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.metalocator.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# Too many fields?

There is no fixed limit on the number of fields you can add to MetaLocator.  However, some customers can create enough fields to exceed the _maximum size of a row_ supported by our underlying database system.

This row size limit reflects the total combined length of all fields.

The solution to this problem is to more properly size the fields to accommodate the data.  The default field size is 255 characters.  However, this can be more than enough for columns that contain very short data.

To modify a field to a shorter length, click **Fields**, then the name of the field.

Click **Field Details** and choose a different, shorter, field length as shown below.

Click **Save**.

Warning: If there is content in the field that is longer than the chosen length it will be automatically truncated to fit the new length.  
​

[![](https://storage.crisp.chat/users/helpdesk/website/-/d/7/1/5/d715eae234755000/0f185f6c-348c-43b3-9e15-ae2060_1fazupd.png)](https://downloads.intercomcdn.com/i/o/59330346/9b83b25cc32db0f0e2c62727/image.png?expires=1794513600&signature=c5e9b4c4a732808609923fd0de882181e1e22a694295c26035d0d3d990a8b141&req=cSkkFcl9mYcTWLcX3D%2B5hh%2B5mEALnFuw4iNCWC%2B%2Fw2OgDgBQasMZxTIn%2FCpa%0AEwtAN%2F8DrFF60um7%0A)

Another strategy to shorten fields is to change the field type.  For example, a field that contains a single number can be changed to a numeric field type instead of a text field type.

[![](https://storage.crisp.chat/users/helpdesk/website/-/3/b/f/3/3bf3263895289000/4741fad3-dd46-4d62-8b42-018f74_hz2ncl.png)](https://downloads.intercomcdn.com/i/o/59330936/a3f70a4d772ae4114f847b9c/image.png?expires=1794513600&signature=0b5c65a59ef8d74a0cd1ccc9b72d73f8a747416b209377a0a57387bf9537168f&req=cSkkFcl3nocTWLcX3D%2B5hpgC2Py7HOfEgXZUuxptFL67EVd7QXt4Sh8uvurv%0AOXVKRBOsQy%2Bgc6Tu%0A)