U4-1459 - Textstring Datatypes stores values in NText field when used on Membertype

Created by Richard Soeteman 14 Jan 2013, 05:03:23 Updated by Sebastiaan Janssen 15 Jan 2013, 22:15:01

I have a Membertype and added a Textstring property called department. The TextString property is configured to use NVarchar as datacolumn to store it's values. When I create a member, the data for department is stored in the NText column instead of the NVarchar column in the table cmsPropertyData.


Richard Soeteman 15 Jan 2013, 14:06:14

Will it be fixed or not? Since NText is very bad for performance. And member functionality isn't the fastest already.

Phil Harvey 15 Jan 2013, 14:48:53

ntext is depreciated in SQL 2005+. should the ntext column be converterd to nvarchar(max)?

Niels Hartvig 15 Jan 2013, 15:16:44

Fixed in changeset e4dfff53d320

Priority: Major

Type: Bug

State: Fixed

Assignee: Niels Hartvig

Difficulty: Normal


Backwards Compatible: True

Fix Submitted:

Affected versions: 6.0.0

Due in version: 6.0.0


Story Points: