We would also need to change and test the alter table statements for mssql to do the table column change (addition, deletion, renaming).

Dylan,

Would this not be a good candidate to do at the same time? Seeing as we are forcing people to export / import anyhow?

Dylan,

Was this done as part of the general data-type upgrade in 3.7?

> In particular, I'm not clear on step 3. Are you implying that we should do a complete JIRA back-up to XML, drop and recreate the database, and then restart JIRA and import the back-up?

Sorry for not being clear. Yes, I mean drop the database, recreate it (so it's empty), then load JIRA and import a JIRA backup.

The purpose of this is to change the database column types from TEXT to NTEXT.

Cheers,
Jeff

I had this problem for a long while as well, and then something changed in our environment and it suddenly started working. It was being tracked in JRA-7455 and JRA-8371. Maybe reading the conversations on those issues will help you.

Hi Jeff,

We are running into this problem with version 3.6.1. Can you elaborate on the procedure to fix the problem? In particular, I'm not clear on step 3. Are you implying that we should do a complete JIRA back-up to XML, drop and recreate the database, and then restart JIRA and import the back-up? Or, are you implying that we should using the SQL Server tools to back-up the contents of the database, drop it, recreate it, and restore it?

Thanks,
Randy

To fix this locally in JIRA Standalone:

1. Edit atlassian-jira/WEB-INF/classes/entitydefs/fieldtype-mssql.xml
2. Change these three lines from:

       <field-type-def type="very-long" sql-type="TEXT" java-type="String"></field-type-def>
       <field-type-def type="extremely-long" sql-type="TEXT" java-type="String"></field-type-def>
       <field-type-def type="text" sql-type="TEXT" java-type="String"></field-type-def>
   

   to:

       <field-type-def type="very-long" sql-type="NTEXT" java-type="String"></field-type-def>
       <field-type-def type="extremely-long" sql-type="NTEXT" java-type="String"></field-type-def>
       <field-type-def type="text" sql-type="NTEXT" java-type="String"></field-type-def>
   

3. Drop and recreate the database in SQL Server
4. Restart JIRA.

This is because in 3.1 we introduced the 'extremely-long' data type, and mapped it to TEXT in SQL Server. It should have been mapped to NTEXT, which can handle Unicode.