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:
-
Database:Microsoft SQL
-
Testing Instructions:
-
Affected Branches:MOODLE_20_STABLE
-
Fixed Branches:MOODLE_26_STABLE
-
Pull from Repository:
-
Pull Master Branch:w31_
MDL-11270_m26_nvarcharmax -
Pull Master Diff URL:
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