WMS - wms_format..data_format column not long enough

[mschulz]

Loading of a wms service from cubewerx failed due to the long image format names they provide: ERROR - column too short (50). Column data_format of table wms_format is defined as char varying (50) - they use format names with a length of around 70.

[anonymous]

Museum of modern art moma Child museum in new jersey

[sven]

change column data_format in wms_format: set length from 50 to 100

[christoph]

PostgreSQL

ALTER TABLE wms_format ALTER COLUMN data_format TYPE varchar(100);

MySQL

ALTER TABLE wms_format CHANGE data_format data_format VARCHAR(100);