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

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Unresolved
    • None
    • Component/s: Environment - Database
    • None
    • 1
    • 1

      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)

            Assignee:
            Unassigned
            Reporter:
            Alex [Atlassian,PSE]
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: