nvarchar

  • Comments posted to this topic are about the item nvarchar

  • oh come on! How does N-Var-Char translate to this answer!

    I hesitated to answer because none of the anwers seemed correct and when I finally did I was greeted to this. Why not call the site CentralServer.com too.

    Rich

  • I wasn't sure which way to go either between "national character varying" & "national varying character", but then I saw this in BOL so I chose the former.

    (nvarchar data type): The ISO synonyms for nvarchar are national char varying and national character varying.

    But the question doesn't mention ISO so I agree that it's ambiguous.

  • Since the abbreviation is "nvarchar" I can see National VARying CHARacter. How did it become National CHARacter VARying? If that was the case shouldn't it be ncharvar? I would appreciate a review of this question.

    Cheers,

    Brian

  • My reasoning was the items held in the datatype were of the National Character Set, so National Character varying was a better answer. Even though the abbreviation would suggest National varying character -- in other words a lucky guess.

  • Probably for the same reason we drive on a parkway and park on a driveway. 😛

    I had to look it up, but I know some consider that cheating. 😉

  • Look at it this way, it's nchar varying. So if you were to follow it to it's logical name (varying char = varchar) it should have been called a varnchar from the very beginning!?

    char = character

    varchar = character varying

    nchar = national character

    nvarchar = national character varying

    It made sense to me, anyway...:hehe:

    --------
    [font="Tahoma"]I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams[/font]

  • I think MS found it easier to say "varchar" rather then "charvar"

  • see above for sore losers 😛

    been there to - them questions be scurvy, argh

    the be question real should: "it why ivarchar isn't?" like I[/b]nternational

    Edit: Chad you make me want me have Kitt as my avatar

    Max

  • Richard Driscoll (5/28/2009)


    oh come on! How does N-Var-Char translate to this answer!

    I hesitated to answer because none of the anwers seemed correct and when I finally did I was greeted to this. Why not call the site CentralServer.com too.

    Rich

    Hmm, sour grapes I think. No one ever said that the n-var-char was a direct acronym.

  • Call it sour grapes if you will but I had never heard it referred to as anything but national variable character before today. So now I have been publically humbled …if this is the worst that happens to me today I will consider myself very lucky!

    Rich

  • I have seen sites state that the n stands for unicode. :w00t:

  • Max (5/28/2009)


    Edit: Chad you make me want me have Kitt as my avatar

    Ahhhhh.... someone who knows both their aircraft and their cars! 😀

  • Richard Driscoll (5/28/2009)


    oh come on! How does N-Var-Char translate to this answer!

    Ask the people who created the ISO standards, as that's where it comes from!

  • Chad Crawford (5/28/2009)


    Max (5/28/2009)


    Edit: Chad you make me want me have Kitt as my avatar

    Ahhhhh.... someone who knows both their aircraft and their cars! 😀

    Yeah, something about midnight-black, shiny and fast (not to mention the awesome arsenal), can't put my finger on it... :w00t:

    Max

Viewing 15 posts - 1 through 15 (of 19 total)

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