If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Data Access, Manipulation & Batch Languages > ANSI SQL > Ansi

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-02-07, 13:51
Brett Kaiser Brett Kaiser is offline
Window Washer
 
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
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.
Reply With Quote
  #2 (permalink)  
Old 08-02-07, 13:58
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
ANSI = american national standards institute

ANSI is spelled I-S-O
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #3 (permalink)  
Old 08-02-07, 17:43
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
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
Reply With Quote
  #4 (permalink)  
Old 08-02-07, 18:02
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
in that case, let me cast my vote for "Standard SQL"

which should eliminate any confusion, eh
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #5 (permalink)  
Old 08-02-07, 23:18
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
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
Reply With Quote
  #6 (permalink)  
Old 08-03-07, 08:35
urquel urquel is offline
Registered User
 
Join Date: Aug 2004
Posts: 330
All this time i've been spelling it "antsy".
Reply With Quote
  #7 (permalink)  
Old 08-14-07, 12:16
rguy84 rguy84 is offline
Registered User
 
Join Date: Jun 2004
Location: Seattle, WA
Posts: 601
What about Straight-up SQL?
__________________
Ryan
My Blog
Reply With Quote
  #8 (permalink)  
Old 08-14-07, 14:23
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
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:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #9 (permalink)  
Old 08-14-07, 14:25
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,524
excellent idea, i want to change my vote to Structured Query Language too

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #10 (permalink)  
Old 08-14-07, 14:38
pootle flump pootle flump is offline
King of Understatement
 
Join Date: Feb 2004
Location: One Flump in One Place
Posts: 14,905
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:
Quote:
pootle flump
ur codings are working excelent.
Reply With Quote
  #11 (permalink)  
Old 08-16-07, 10:43
rguy84 rguy84 is offline
Registered User
 
Join Date: Jun 2004
Location: Seattle, WA
Posts: 601
haha check out Brazil...
__________________
Ryan
My Blog
Reply With Quote
  #12 (permalink)  
Old 08-16-07, 10:48
Brett Kaiser Brett Kaiser is offline
Window Washer
 
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
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.
Reply With Quote
  #13 (permalink)  
Old 08-16-07, 15:53
rguy84 rguy84 is offline
Registered User
 
Join Date: Jun 2004
Location: Seattle, WA
Posts: 601
no way man
__________________
Ryan
My Blog
Reply With Quote
  #14 (permalink)  
Old 08-17-07, 04:32
stolze stolze is offline
Registered User
 
Join Date: Jan 2007
Location: Jena, Germany
Posts: 2,662
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
Reply With Quote
  #15 (permalink)  
Old 09-18-07, 14:35
Brett Kaiser Brett Kaiser is offline
Window Washer
 
Join Date: Nov 2002
Location: Jersey
Posts: 10,303
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On