Difference with DataLength and Len with CHAR and NVARCHAR Datatype

  • good question:-)

  • Koen Verbeeck (7/11/2014)


    Why is DATALENGTH() included in the question? The first two results are the same for all answers 🙂

    Nice 😉

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • This was so simple that I suspected a catch. 🙂

    Thanks, Mitesh!

  • pmadhavapeddi22 (7/10/2014)


    I have actually thought of this question yesterday :-), I am surprised to see it today.

    (of course, I don't have plans to submit as QOTD)

    This is a little bit spooky - I was considering submitting my first QotD on exactly this topic earlier this week too!

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply