Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I found a general comparision of different SQL implementations that only covers some data types (BOOLEAN and TIMESTAMP) and a comparision of datat type support in different RDBMS from 2009 that does not list which data types are standard since when. Do you know of any comparision that lists SQL data types together with their introduction (SQL-86, SQL-92, SQL:1999, SQL:2003...)? For instance INTERVAL, ARRAY/MULTISET, and XML have been introduced later and some time still wait to be widely implemented (or never will be).

P.S: In database speech, I am looking for values to fill:

CREATE TABLE datatype (
  name VARCHAR(20) NOT NULL,                    -- official name, e.g. "ARRAY"
  degreeofsupport VARCHAR(100),                 -- can also be subjective
  introduced REFERENCES sqlversion.id NOT NULL, -- e.g. SQL-92
  id INTEGER PRIMARY KEY
);

CREATE TABLE rdbmssupportsdatatype (
  datatypeid REFERENCES datatype.id NOT NULL,
  rdbmsid REFERENCES rdbms.id NOT NULL,     -- specific version or product
  name VARCHAR(20),                         -- specific name in this RDBMS
);
share|improve this question
2  
This is quite a vague question and difficult to get all the info together eg I don't know of any publicly available copy of SQL 2003. So why? –  gbn Aug 19 '11 at 8:36
    
I'd like to now which datatypes have been proposed as part of standard SQL over the years and which actually got implemented. –  Jakob Aug 19 '11 at 9:20
    
The question as asked is a little too vague for my tastes. I don't mind re-opening if you can provide a firmer grasp of what it is you're looking for and why a simple google search doesn't give you the answers. Are you looking for SQL history? –  jcolebrand Aug 19 '11 at 18:34
    
Can you please reopen the question? I provided links to resources that partly answer my question: I am looking for an overview of SQL datatypes, together with when their were introduced and which RDBMS supports them: –  Jakob Aug 21 '11 at 16:51
    
I this question closed because it is displeasing to the DBA community? I thought that SQL datatypes and their actual support (and non-support) in RDBMS is rather fundamental, isn't it? –  Jakob Aug 24 '11 at 11:59
add comment

closed as not a real question by gbn, Marian, jcolebrand Aug 19 '11 at 18:33

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Browse other questions tagged or ask your own question.