[MDL-11270] Analyse the impact and roadmap to move, under MSSQL, from ntext to nvarchar(max) - Moodle Tracker

XML

Word

Printable

Database:

Microsoft SQL
Testing Instructions:

Hide

1/ upgrade from 2.2 and 2.5
2/ install
3/ execute phpunit tests

repeat with freetds and native drivers

Show
1/ upgrade from 2.2 and 2.5 2/ install 3/ execute phpunit tests repeat with freetds and native drivers
Affected Branches:
MOODLE_20_STABLE
Fixed Branches:
MOODLE_26_STABLE
Pull from Repository:
https://github.com/skodak/moodle.git
Pull Master Branch:
w31_~~MDL-11270~~_m26_nvarcharmax
Pull Master Diff URL:
https://github.com/skodak/moodle/compare/w31_MDL-11270_m26_nvarcharmax

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:

has a non-specific relationship to

MDL-48744 NTEXT to NVARCHAR(MAX) column conversion in MSSQL Fails to truncate

MDL-26597 admin/replace.php fails under MSSQL

will help resolve

MDL-9845 Use nvarchar(max) instead of ntext for MSSQL 2005