TWiki
>
IVOA Web
>
GerardLemson
>
GerardLemsonTAP_031
>
GerardLemsonADQLDataTypes
(revision 3) (raw view)
Edit
Attach
Overview of SQL datataypes based on SQL 2003 (as it seems most extensive). "x" in column implies it exists also in other SQL versions, or is anticipated by ADQL. VOTable column gives likely mapping to VOTable data type. a "[(P[,S])]" after a datatypeps indicates that a precision (P) and possibly a scale(S) can be provided. For info on database support this look at JVO presentation during Victoria 2006 interop. Also various JDBC mapping tables such as [[http://java.sun.com/j2se/1.4.2/docs/guide/jdbc/getstart/mapping.html][this]]. In table stick to predefined data types. SQL 2003 and 99 also various user defined types such as ROW etc. NB complete matching to other versions of SQL etc. | *[[http://savage.net.au/SQL/sql-2003-2.bnf.html][SQL 2003]]* | *[[http://savage.net.au/SQL/sql-92.bnf.html][SQL 92]]* | *[[http://savage.net.au/SQL/sql-99.bnf.html][SQL 99]]* | *[[http://www.ivoa.net/Documents/REC/ADQL/ADQL-20081030.pdf][ADQL 2.0]]* | *[[http://java.sun.com/javase/6/docs/api/java/sql/Types.html][JDBC type]][[#FootNote4][<sup>4</sup>]]* | *[[http://www.ivoa.net/internal/IVOA/IvoaVOTable/VOTable-beta.xsd][VOTable 1.2 (beta)]]* | |CHARACTER [(P)]| o | o | o |CHAR | | |CHAR [(P)] | o | o | o |CHAR | | |CHARACTER VARYING[(P)] | o | o | o |VARCHAR | | |CHAR VARYING [(P)] | o | o | o |VARCHAR | | |VARCHAR [(P)] | o | o | o |VARCHAR | | |CHARACTER LARGE OBJECT [(P)][[#FootNote1][<sup>1</sup>]] | x | o | x |CLOB | | |CHAR LARGE OBJECT [(P)][[#FootNote1][<sup>1</sup>]] | x | o | x |CLOB | | |CLOB [(P)][[#FootNote1][<sup>1</sup>]] | x | o | x |CLOB | | |NATIONAL CHARACTER [(P)]| o | o | o |NCHAR | | |NATIONAL CHAR [(P)] | o | o | o |NCHAR | | |NCHAR [(P)] | o | o | o |NCHAR | | |NATIONAL CHARACTER VARYING[(P)] | o | o | o |NVARCHAR | | |NATIONAL CHAR VARYING [(P)] | o | o | o |NVARCHAR | | |NCHAR VARYING [(P)] | o | o | o |NVARCHAR | | |NATIONAL CHARACTER LARGE OBJECT [(P)][[#FootNote1][<sup>1</sup>]] | x | o | x |NCLOB | | |NCHAR LARGE OBJECT [(P)][[#FootNote1][<sup>1</sup>]] | x | o | x |NCLOB | | |NCLOB [(P)][[#FootNote1][<sup>1</sup>]] | x | o | x |NCLOB | | |BINARY LARGE OBJECT [(P)][[#FootNote1][<sup>1</sup>]] | x | o | x |BLOB | | |BLOB [(P)][[#FootNote1][<sup>1</sup>]] | x | o | x | BLOB | | |NUMERIC [(P[,S])]| o | o | o |NUMERIC | | |DECIMAL [(P[,S])]| o | o | o |DECIMAL | | |DEC [(P[,S])] | o | o | x |DECIMAL | | |INTEGER | o | o | o |INTEGER | | |INT | o | o | o |INTEGER | | |SMALLINT | o | o | o |SMALLINT | | |BIGINT | x | x | x | BIGINT | | |FLOAT [(P)] | o | o | o |FLOAT | | |REAL | o | o | o |REAL | | |DOUBLE PRECISION | o | o | o |DOUBLE | | |BOOLEAN | x | o | x |BOOLEAN | | |DATE | o | o | o |DATE | | |TIME [(P)][[#FootNote2][<sup>2</sup>]]| o | o | o | TIME | | |TIMESTAMP [(P)][[#FootNote2][<sup>2</sup>]] | o | o | o |TIMESTAMP | | |INTERVAL ... [[#FootNote3][<sup>3</sup>]]| o | o | o | x| | | x |BIT [(P)] | o | o |BIT? | | | x |BIT VARYING [(P)]| o | o |BIT? | | #FootNote1 <sup>1</sup> The syntax for sizes of large objects is actually somewhat different from the "[(P)]" applicable to simpler data types.<br/> #FootNote2 <sup>2</sup> The syntax for sizes of TIME and TIMESTAMP is actually somewhat different from the "[(P)]" applicable to simpler data types.<br/> #FootNote3 <sup>3</sup> See the [[http://savage.net.au/SQL/sql-2003-2.bnf.html#interval%20type][SQL 2003 grammar]] for precise specification of INTERVAL type.<br/> #FootNote4 <sup>4</sup> JDBC's java.sql.Types defines many other types that do not appear in any of the SQL standards, but correspond to database type systems. <br/> <!-- * Set ALLOWTOPICRENAME = %MAINWEB%.TWikiAdminGroup -->
Attachments
Attachments
Topic attachments
I
Attachment
History
Action
Size
Date
Who
Comment
txt
adqltypes.txt
r1
manage
13.2 K
2009-03-23 - 07:04
GerardLemson
Edit
|
Attach
|
Watch
|
P
rint version
|
H
istory
:
r6
<
r5
<
r4
<
r3
<
r2
|
B
acklinks
|
V
iew topic
|
Raw edit
|
More topic actions...
Topic revision: r3 - 2009-03-23
-
GerardLemson
IVOA
Log in
or
Register
IVOA.net
Wiki Home
WebChanges
WebTopicList
WebStatistics
Twiki Meta & Help
IVOA
Know
Main
Sandbox
TWiki
TWiki intro
TWiki tutorial
User registration
Notify me
Working Groups
Applications
Data Access Layer
Data Model
Grid & Web Services
Registry
Semantics
Interest Groups
Data Curation
Education
Knowledge Discovery
Operations
Radio Astronomy
Solar System
Theory
Time Domain
Committees
Stds&Procs
www.ivoa.net
Documents
Events
Members
XML Schema
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback