User Profile Management - Multi-valued profile property mapped to the nvarchar(MAX) field in the SQL table.

Author

Multi-valued profile property mapped to the nvarchar(MAX) field in the SQL table.

Eugene B

2006-09-12, 7:39 pm

Recently, modifying one on the profile types, I ran into strange glitch.
One of the original profile properties, which was defined as multi-valued,
and mapped to the SQL field with the type of nvarchar(255), "stopped
working" after I promoted field to the nvarchar(MAX) SQL data type. Problem
was solved when I reduced field size to the nvarchar(4000). But now I really
need to create new profile type with the multi-valued property, holding big
array of data. I would want to use nvarchar(MAX) SQL table field for
storage. Does anybody know if it is possible to use nvarchar(MAX) for that
purpose, are there any limitations under CS2007 on usage of such data type,
and if it is possible to overcome those limitations?

Thank you, in advance, for any inputs.

Sincerely,

Eugene B