• IowaDave (7/11/2012)


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

    Thanks!

    Because it is the entire length of the string * 2 bytes. Nchar includes padding so the length is 40 versus 7 with nvarchar which does not include padding.