I apologise if this is covered somewhere but I cannot find the answer anywhere.

When creating a new multi-select field the actual field within the database is created with a data type of nvarchar(255). This means that if you combined multi-select values contains more than 255 characters then the record cannot be saved.

This is easily changed within SQL itself but I am wary of doing this. Can a multi-select field be safely converted into say nvarchar(max) so that large lists can be saved?

I am aware that one work around could be to use small codes, however this will make the database hard to read when querying from external sources.