Setting Length for String Database Columns
The length for most String type database columns is 255.
To change the length of any additional String type database columns run the following command as appropriate for your database. The example commands provided increase the column length to 4000.
• For Postgres: ALTER TABLE <table name> ALTER COLUMN <column name> TYPE varchar(4000);
For example, for the illustrationame column on the workdefinitionillustration database table, run the command:
ALTER TABLE workdefinitionillustration ALTER COLUMN illustrationname TYPE varchar(4000);
• For MSSQL: ALTER TABLE <schema>.<table name> ALTER COLUMN <column name> NVARCHAR(4000);
For example, for the illustrationame column on the workdefinitionillustration database table, for a database using the twschema schema, run the command:
ALTER TABLE twschema.workdefinitionillustration ALTER COLUMN illustrationname NVARCHAR(4000);