Results 1 to 15 of 15

Thread: Ansi

  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: Ansi

    What is ANSI SQL and how do you spell ANSI?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    ANSI = american national standards institute

    ANSI is spelled I-S-O
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Right, I would also suggest to rename this forum to "ISO SQL". ANSI is "just" a national body that participates in the standardization process. SQL comes from ISO and ANSI merely copies it into a national standard.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    in that case, let me cast my vote for "Standard SQL"

    which should eliminate any confusion, eh
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I always find it amusing when dealing with users around the world that ANSI is recognized worldwide, and has only one commonly used expanded form (American National Standards Institute). While there are a few companies that have kludged names to allow them to usurp the ANSI acronym, they are oddball efforts which don't seem to confuse newcomers to the technology field.

    ISO on the other hand is recognized much less frequently, with much less certainty, and looking up the full name from the ISO acronym can be very confusing, especially for Asians.

    I can always explain what I mean by the term ISO, and have grown accustomed to simply providing the URL with my first reference in order to avoid confusion. I've never, ever needed to explain what I meant when I used the ANSI acronym.

    I think that we ought to call it "Joe's SQL", in reference to Mr. Celko and his efforts to entice, cajole, or bludgeon everyone onto a single playing field!

    On a slightly more serious note, I like "Standard SQL" as a description, but I'm pretty sure that there is already a United States copyright fight on the phrase. I think that Oracle has first claim on the copyright, but that claim was disputed by Microsoft, IBM, and possibly other companies too. I haven't paid much attention to this, but I remember that the phrase was disputed so that it fell out of general use even by the marketing types.

    I don't really care what we call the forum, but I like the idea of a standards based forum for discussing SQL that is both aware of how the different engines implement SQL, but remains as agnostic as is practical in regard to those implementations.

    -PatP

  6. #6
    Join Date
    Aug 2004
    Posts
    330
    All this time i've been spelling it "antsy".

  7. #7
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    What about Straight-up SQL?
    Ryan
    My Blog

  8. #8
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    We only had a flipping vote on this in private a week ago. Perhaps we need some Standards for renaming forums too.

    Since we are all getting a say I'd like to expand SQL to Structured Query Language - some people pronounce it ESS QUEUE ELLLL and others SEQUEL. It is bound to cause confusion, especially if reading out loud.
    Testimonial:
    pootle flump
    ur codings are working excelent.

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    excellent idea, i want to change my vote to Structured Query Language too

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  10. #10
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Quote Originally Posted by r937
    excellent idea, i want to change my vote to Structured Query Language too

    Blimey - talk about a floating voter - no wonder there are 736 main stream political parties in Canada
    Testimonial:
    pootle flump
    ur codings are working excelent.

  11. #11
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    haha check out Brazil...
    Ryan
    My Blog

  12. #12
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by rguy84
    haha check out Brazil...

    Sure, you buying?

    Just watch out from becoming a hostage
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  13. #13
    Join Date
    Jun 2004
    Location
    Seattle, WA
    Posts
    601
    no way man
    Ryan
    My Blog

  14. #14
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Quote Originally Posted by Brett Kaiser
    Sure, you buying?

    Just watch out from becoming a hostage
    Hostages in Brazil will only become Americans who don't want to have the exactly same rules applied to them as the US applies to all foreigners, i.e. having their picture and finger prints taken at the port of entrance.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  15. #15
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by stolze
    Hostages in Brazil will only become Americans who don't want to have the exactly same rules applied to them as the US applies to all foreigners, i.e. having their picture and finger prints taken at the port of entrance.

    Yeah right

    talk about trying to stop a flood
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

Posting Permissions

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