Wow, I didn’t realize I left this question out.

So here’s the question:

Q:  What’s the difference between char() and varchar()?

A:  With char() you can store the standard set of characters.  And with varchar() you can store the extended set… pretty much any character you can think of can be stored in varchar() whereas with char() you can only store the standard 50.  I think it’s 50.  Maybe it’s 53 or something.  I forget the exact number, but it’s about 50. 

So that’s when I asked him about the difference between char() and nchar() because that usually kicks them in line and they go, oh wait, y, so char() holds regular data and nchar() holds extended data.  So that means varchar() holds… and then whatever they come up with next.

But not this guy, no, he stuck to his guns and went with nchar() holding numeric character data.

You’ve gotta love someone who sticks to their guns no matter what!

Tagged with:

5 Responses to The Dumbest man on Earth -char() vs varchar()

  1. mgroves says:

    What an idiot! Everyone knows varchar is for storing “Var”ious text data, while char and nchar storing uniform text data.

  2. Matt Velic says:

    I could make a political comparison as a joke at this point, but I don’t wish to offend anyone of any particular affiliation. But with that, I’m guessing I don’t have to say another word. :-)

  3. Jeff Rush says:

    Wait, doesn’t char have to do with burning something?

    I’m so confused now.

    You people and your crazy sequel stuff, i don’t need sequel, I haven’t even seen the original!

  4. Neil Hambly says:

    Your say he stuck to his Guns.. you mean you let him in with a gun on him..well that was brave consider everything LOL

  5. [...]  While in the prep room, we talked about some blog posts from Sean McCown (Blog | Twitter) about bad interviews.  In short, Sean shared some of his interview experiences.  If you read Sean’s rant/series [...]

Leave a Reply

Set your Twitter account name in your settings to use the TwitterBar Section.