How do I increase the field length of the mobile phone field from 15 to 25 character in the Users table?

Symptom

• You want to increase the field length from 15 to 25 characters for the Mobile Phone field in the Users table

Applies to

• ILLiad

Resolution

Here is what you need to do::

1. The command you follow is ALTER TABLE table_name ALTER COLUMN column_name datatype;

   An example for the mobilephone field would be:

   ALTER TABLE Users ALTER COLUMN Mobilephone nvarchar(25).

2. You need to petition ATLAS Support to update the mobilephone field because the next time you upgrade, your phone numbers will be truncated back to 15 characters.

Page ID