Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-11270

Analyse the impact and roadmap to move, under MSSQL, from ntext to nvarchar(max)

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0
    • Fix Version/s: 2.6
    • Component/s: Database SQL/XMLDB
    • Labels:

      Description

      It seems that ntext is deprecated in latest MSSQL versions and the recommended way is to use nvarchar(max) instead.

      Analyse how we can change that, their impact both in dml and ddl libraries.

      Some initial references:

      http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=421702&SiteID=1
      http://msdn2.microsoft.com/en-US/library/ms189087.aspx

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              skodak Petr Skoda
              Reporter:
              stronk7 Eloy Lafuente (stronk7)
              Peer reviewer:
              Eloy Lafuente (stronk7)
              Integrator:
              Sam Hemelryk
              Tester:
              Rajesh Taneja
              Participants:
              Component watchers:
              Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              12 Vote for this issue
              Watchers:
              16 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                18/Nov/13