mysql string size limit

Question

Hi

when i want to restore a xml backup-file in jira that use mysql ,i get an error about string size limitiotin for some custom fields , what's the problam and what does can i do ?

i can use this backup file when i using hsql , but i cant restore it when i using mysql

thanks a lot

pkirkeby · Answer

The error looks like the table is 'customfieldvalue' and the column 'stringvalue' needs extending. For MySQL I believe the syntax would be something like:

ALTER TABLE customfieldvalue MODIFY stringvalue VARCHAR(512);

mehran haghani · Answer

thanks Pelle,

how can i change it ? in wich table?

is there any way to convert all stringvalue to nvarchar or bumping all of them to 512 ?

pkirkeby · Answer

That does look like the column length needs to be extended.

Stringvalue in that table is restricted to 255 characters, so bumping that up to 512 will hopefullly suffice :)