nvarchar

Question

nvarchar

VM-723206

SSCrazy

Points: 2964
More actions
May 27, 2009 at 8:14 pm

#210120

Comments posted to this topic are about the item nvarchar

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

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

Richard Driscoll SSCommitted Points: 1541 More actions · Answer 1

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

craigpessano SSCertifiable Points: 5358 More actions · Answer 2

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.

beezell Hall of Fame Points: 3112 More actions · Answer 3

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

brdudley SSCrazy Points: 2320 More actions · Answer 4

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.

Chad Crawford SSChampion Points: 11610 More actions · Answer 5

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. 😉

Rob Goddard SSCrazy Points: 2622 More actions · Answer 6

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]

Steve Jones - SSC Editor SSC Guru Points: 736105 More actions · Answer 7

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

Max-146500 SSCarpal Tunnel Points: 4691 More actions · Answer 8

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 9

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.

Richard Driscoll SSCommitted Points: 1541 More actions · Answer 10

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

OCTom SSChampion Points: 11785 More actions · Answer 11

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

Chad Crawford SSChampion Points: 11610 More actions · Answer 12

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! 😀

Toreador SSChampion Points: 11365 More actions · Answer 13

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!

Max-146500 SSCarpal Tunnel Points: 4691 More actions · Answer 14

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