Dave Burke : Freelance .NET Web Developer specializing in Online Communities

To SPS2003 : Considering the 255 NVarChar limit

Funny how 255 continues to be a basic data construct in the most modern of information systems.  I learned some time ago the technical reasons for why this came to be, but I had since forgotten and now don't care.

But SPS2003's document description (title, and other single-line property fields) are nvarchar255 fields.  You can hit that 255 limit pretty quickly and I'm sure I'll be hearing about this from my users once we go online with our SPS2003-based migrated intranet system.

The item description is stored in the nvarchar8 field of the Sharepoint Site UserData table.  I guess I could go in a bump it up a bit, but I've only been working with Sharepoint 2003 for going on 3 weeks and I don't feel like going in and screwing with the design of the basic system tables...

 

Comments (0) | Post RSS RSS comment feed

Posted on 6/9/2004 1:43:00 PM by Dave Burke
Categories:
Tags: no tags for this post

Related posts


Powered by BlogEngine.NET 2.0.0.36
Theme by Dave Burke