The Dumbest man on Earth -char() vs varchar()

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!

5 thoughts on “The Dumbest man on Earth -char() vs varchar()”

  1. 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. :-)

  2. 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!

Leave a Reply