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

Details

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

    Description

      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)

      Attachments

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated: