[AttributeValue] size column in DB is too small

Jan 7, 2010 at 3:49 PM
Edited Jan 7, 2010 at 3:51 PM


I just realized that AttributeValue column of table [netsqlazman_ItemAttributesTable] is limited to nvarchar(4000).

Why don't change the type to nvarchar(max) (along with 2 stored procedures [netsqlazman_ItemAttributeInsert] and  [netsqlazman_ItemAttributeUpdate]) so that we can store whatever we need.

If you don't want to stick to SQL Server 2005, another option would be to define the field as ntext.

What do you think ?


PS: The justification for big size is that I use the attribute to store a xml serialized list of objects that could get pretty big.



Jan 8, 2010 at 8:45 AM


Attributes are defined as nvarchar(4000) to mantain the SQL 2000 compatibility.

The NetSqlAzMan ver 4.0 will support SQL 2005 or later.

In the 4.0 release I will change it to nvarchar(max)/ntext.



Andrea Ferendeles
NetSqlAzMan Project Coordinator  
E-mail aferende@hotmail.com Web http://netsqlazman.codeplex.com