Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-76241

Migrate ofbiz away from ntext datatype for Microsoft SQL Server entity types

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • Environment - Database
    • None
    • 1
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      Issue Summary

      Ofbiz uses ntext data type for very-long, extremely-long, and text data types:

      jira/jira-components/jira-core/src/main/ofbiz/entitydefs/fieldtype-mssql.xml

          <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>

      According to Microsoft, ntext, text and image data types will be removed in a future version of SQL Server

      Recommendation

      Migrate these data types to either nvarchar(max), or varchar(max)

              Unassigned Unassigned
              allewellyn@atlassian.com Alex [Atlassian,PSE]
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: