• IowaDave (7/11/2012)


    Why does datalength of nchar(40) give 80?!?? That really threw me.

    Thanks!

    Because the "n" means the string is Unicode, so it has two bytes per character; DATALENGTH returns the actual length of the storage used for the field. 2 bytes per character * 40 characters = 80 bytes.