Post reply

SQL Server SQL Is ANSII Standard or ASCII?

  • April 14, 2009 at 4:27 am

    #133046

    Hi all,

    what is the major difference between ANSII AND ASCII.

    And we have ANSII SQL-92..ETC., What is the meaning of it.

    thanks,

    🙂

  • April 14, 2009 at 4:57 am

    #977117

    ANSI - American National Standards Institute. It's an organisation that sets standards

    ACSII - American Standard Code for Information Interchange. It's a standard for encoding of characters in binary.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 14, 2009 at 9:48 pm

    #977826

    Is sqlserver sql is ansi standard or ascii standard

    🙂

  • April 15, 2009 at 5:28 am

    #977971

    vrabhadram (4/14/2009)

    Is sqlserver sql is ansi standard or ascii standard

    Yes.

    SQL Server is compliant with most of the ANSI standard for SQL.

    SQL Server supports and works with ASCI text.

    This just is not an either/or question.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • April 15, 2009 at 6:57 am

    #978023

    vrabhadram (4/14/2009)

    Is sqlserver sql is ansi standard or ascii standard

    They don't relate to the same thing. ASCII is a set of characters for computers. When you type on a computer screen, if you're limited to the "Roman alphabet" (letters like "AaBbCc", plus numbers and a few punctuation marks and such), that's ASCII. If you can type things like Greek letters, Russian (Cyrilic) letters, Chinese characters, etc., then it's Unicode, instead of ASCII.

    For more details on that, I recommend reading about them online. Wikipedia has reasonably good articles about both ASCII and Unicode.

    ANSI is a different thing entirely. The American National Standards Institute (ANSI) publishes standards for a wide variety of things. They're the ones who publish standards for film (like in a camera), and for a huge number of other things, including for SQL.

    They have published several versions of the SQL standards, and MS SQL is compliant with some of those standards and non-compliant with other ones. So is every other major database system.

    Again, I recommend looking up ANSI online. It'll help.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • April 15, 2009 at 7:12 am

    #978039

    Is this general curiosity or do you need to determine if one of them is actually needed for an application?

  • April 20, 2009 at 7:27 am

    #980693

    One similarity is that they are both acronyms that begin with A, end with I and have an S somewhere in the middle.

    Steve

  • May 2, 2009 at 2:54 am

    #987678

    for only general information,

    🙂

  • May 2, 2009 at 8:55 pm

    #987786

    http://www.google.com/search?hl=en&q=ansi+92

    http://www.google.com/search?hl=en&q=ascii&aq=f&oq=

    😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 9 posts - 1 through 8 (of 8 total)

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