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

Use nvarchar(max) instead of ntext for MSSQL 2005

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Duplicate
    • 1.8
    • 1.9
    • Database SQL/XMLDB
    • None
    • MSSQL 2005
    • Microsoft SQL
    • MOODLE_18_STABLE
    • MOODLE_19_STABLE

    Description

      See http://msdn2.microsoft.com/en-us/library/ms178158.aspx

      The main reason is that ntext fields can't be compared properly so queries with UNIONs fail (for example, the big query in get_my_courses in lib/datalib.php, you get an error message like "The ntext data type cannot be selected as DISTINCT because it is not comparable."). nvarchar(max) is new in MSSQL 2005, so it won't be compatible with earlier versions.

      Attachments

        Issue Links

          Activity

            People

              skodak Petr Skoda
              trick Alan Trick
              Andrew Lyons, Huong Nguyen, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                3/Mar/08