[RESOLVED] preposterous 8000 limit in SQLServer fields

[Phill64]

If you're using varchar, varbinary or the like then you can specify the width of the field up to 8000 bytes (so 4000 characters for nvarchar) or else you can specify 'max'. Data that goes beyond the 8000 byte limit is stored external to the record itself for efficiency, hence the differentiation.

Thanks jm,

you're always full of useful knowledge!