Size of nvarchar(max)??

  • Shiva N

    Hall of Fame

    Points: 3125

    Comments posted to this topic are about the item Size of nvarchar(max)??

    Thanks,
    Shiva N
    Database Consultant

  • Toreador

    SSChampion

    Points: 11253

    It was a 50-50 guess as to whether "size" was supposed to mean storage size or number of characters. I guessed wrong 🙁

    Surprise that (at the time of writing) the number of people making the same wrong guess is outnumbered by those going for 2MB!

  • This was removed by the editor as SPAM

  • TomThomson

    SSC Guru

    Points: 104773

    Toreador (6/23/2015)


    It was a 50-50 guess as to whether "size" was supposed to mean storage size or number of characters. I guessed wrong 🙁

    Surprise that (at the time of writing) the number of people making the same wrong guess is outnumbered by those going for 2MB!

    I didn't think there was a 50-50 guess, because "size" and "length" are quite different concepts. It's quite normal to say that an nchar string has twice teh size of a char string of the same length. But I can see that it's an easy trap to fall into.

    I'm not just surprised amazed that more than 1 person in 6 has answered 2MB, I'm amazed.

    Tom

  • Ed Wagner

    SSC Guru

    Points: 286980

    TomThomson (6/23/2015)


    I'm not just surprised amazed that more than 1 person in 6 has answered 2MB, I'm amazed.

    I have to agree that the results to this point are a bit surprising.

  • Hany Helmy

    SSChampion

    Points: 13488

    Toreador (6/23/2015)


    It was a 50-50 guess as to whether "size" was supposed to mean storage size or number of characters. I guessed wrong 🙁

    Surprise that (at the time of writing) the number of people making the same wrong guess is outnumbered by those going for 2MB!

    I also guessed it wrong, but at least learned somthing new today, so thanx.

  • Revenant

    SSC-Forever

    Points: 42467

    I think this was easy, easy. Thanks, Shiva!

  • twin.devil

    SSC-Insane

    Points: 22208

    nice, easy and informative. Thanks for sharing

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Easy one, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Arno Kwetters

    Hall of Fame

    Points: 3373

    That's quite a lot. I didn't know it.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the question.

  • Bhushan Kulkarni

    SSCrazy

    Points: 2829

    Very Easy 🙂

Viewing 12 posts - 1 through 12 (of 12 total)

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