ntext datatype is not converted to nvarchar

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 6.1.30 EE GA3, 6.2.10 EE GA1
• Fix Version/s: 6.1.X EE, 6.2.2 CE GA3 , 6.2.X EE, 7.0.0 M3
• Component/s: Core Infrastructure, Database Upgrade Framework
• Labels:
  • QA-CT
  • QA-TP
  • ee-ts
  • liferay-fixpack-platform-16-6210
  • liferay-fixpack-platform-21-6130
• Environment: SQL Server 2008 R2
• Branch Version/s:
  6.2.x, 6.1.x
• Backported to Branch:
  Committed
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/18497

Steps to reproduce:

1. Set up a 6.1.10 bundle to connect to SQL Server 2008 R2
2. Start a 6.1.10 bundle to create the tables
   Verify that column "xsd" of table "JournalStructure" is ntext
3. Upgrade to 6.1.30
   RESULT: the JournalStructure.xsd is still ntext, but it should be nvarchar