Results 1 to 15 of 15

Thread: character types

  1. #1
    Join Date
    Apr 2007
    Posts
    15

    Unanswered: character types

    i am using sql server 2000, i am new to databases, could you please tell me what are the different character types, example "varchar , numeric...etc"
    How to find out the difference between them....
    Where do i find a tutorial for this kind of basic knowledge ?

    regards

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Homework questions are not permitted on these forums, and ones that are written so brazenly will just invite ridicule at the poster.

    Have a good day now.

    Regards,
    Last edited by r123456; 11-16-07 at 06:02.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    A great resource for this sort of things is our best friend Google...
    Search for "T-SQL data types" and you'll get a lovely handful of links that will tell you exactly what you want to know!

    Once you've had a read, if you any specific questions post them back here!
    George
    Home | Blog

  4. #4
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Oh George, you really are far too tolerant.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    That's because I don't think this one is homework (yet)
    George
    Home | Blog

  6. #6
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    homework is indeed allowed and is often some of the more interesting posts.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  7. #7
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Quote Originally Posted by Thrasymachus
    homework is indeed allowed and is often some of the more interesting posts.
    I'll get my coat.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  8. #8
    Join Date
    Nov 2003
    Location
    London
    Posts
    169
    Hi there,

    Check the SQL server 2000 help file (called books online or BOL), if you do a search on 'data types' you should find everything you need.

  9. #9
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Quote Originally Posted by r123456
    I'll get my coat.
    Well, it is allowed, but it is certainly treated differently.
    We do our best to help the poster to the answer themselves, but if they're unwilling then so are we.

    I can understand why you think this one might be homework - but I personally don't see it yet. If you asked me a year ago what the datatypes were, I could probably name 3
    Not to mention I'd have even less of an idea what "BoL" stands for
    George
    Home | Blog

  10. #10
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    The ignorance of youth.

    Once you get to my age (24) you tend to show less emotion and occasionally affront a manner of indifference, often unknowingly, when you fine yourself in a social predicament. Such causes of this decline to a dour emotional state vary widely, though one that invariably seems to be effective, and which is notably the most prominent, is when one is asked to answer a painfully trivial question. The immediate reaction is to swiftly determine whether the original post was said in jest, an attempted cure to the illness described above, or if in fact, it was a question. Occasionally in exercising this judgment, we may reach the wrong conclusion.
    Last edited by r123456; 11-16-07 at 09:10.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  11. #11
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by r123456
    Occasionally in exercising this judgment, we may reach the wrong conclusion.
    Been there, done that, got the blood-stained tee-shirts to prove it! No serious harm done, such is life.

    Twenty four years old... Yikes, I remember that wistfully!

    -PatP

  12. #12
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Quote Originally Posted by Pat Phelan
    Twenty four years old... Yikes, I remember that wistfully!
    -PatP
    I'll let you know my perspective in the year 2047.
    Last edited by r123456; 11-16-07 at 09:21.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  13. #13
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by r123456
    I'll let you know my perspective in the year 2047.
    Assuming that I'm still alive at that point, I'll be eagerly awaiting your analysis!

    -PatP

  14. #14
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    Quote Originally Posted by r123456
    Once you get to my age (24)
    damn...people around you are gonna be in BIG trouble then, by the time you get to my age (47)
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

  15. #15
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I thought I was ahead of my age in cynicism, but I think Robert may have taken the gold for that

    kc3377, how are you doing with your original question, do you have all the answers you need?
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •