Difference: GerardLemsonADQLDataTypes (1 vs. 7)

Revision 72012-06-26 - root

 
META TOPICPARENT name="GerardLemsonTAP_031"
Overview of SQL datataypes based on SQL 2003 (as it seems most extensive). "o" in column implies it exists also in other SQL versions, is anticipated by ADQL through its list reserved words. The columns JDBC and VOTable give the mapping to those two type systems. A "[(P[,S])]" after a datatypeps indicates that a precision (P) and possibly a scale(S) can be provided.
Changed:
<
<
For info on database support look at JVO presentation during Victoria 2006 interop. Also various JDBC mapping tables such as this.
>
>
For info on database support look at JVO presentation during Victoria 2006 interop. Also various JDBC mapping tables such as this.
 
Changed:
<
<
SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type4 Sort VOTable 1.2 (beta) Sort
>
>
SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type4 Sort VOTable 1.2 (beta) Sort
 
CHARACTER [(P)] o o o CHAR char
CHAR [(P)] o o o CHAR char
CHARACTER VARYING[(P)] o o o VARCHAR char
CHAR VARYING [(P)] o o o VARCHAR char
VARCHAR [(P)] o o o VARCHAR char
CHARACTER LARGE OBJECT [(P)]1 x o x CLOB char (?)
CHAR LARGE OBJECT [(P)]1 x o x CLOB char (?)
CLOB [(P)]1 x o x CLOB char (?)
NATIONAL CHARACTER [(P)] o o o NCHAR char
NATIONAL CHAR [(P)] o o o NCHAR char
NCHAR [(P)] o o o NCHAR char
NATIONAL CHARACTER VARYING[(P)] o o o NVARCHAR char
NATIONAL CHAR VARYING [(P)] o o o NVARCHAR char
NCHAR VARYING [(P)] o o o NVARCHAR char
NATIONAL CHARACTER LARGE OBJECT [(P)]1 x o x NCLOB char (?)
NCHAR LARGE OBJECT [(P)]1 x o x NCLOB char (?)
NCLOB [(P)]1 x o x NCLOB char (?)
BINARY LARGE OBJECT [(P)]1 x o x BLOB unsignedByte6
BLOB [(P)]1 x o x BLOB unsignedByte6
NUMERIC [(P[,S])] o o o NUMERIC x5
DECIMAL [(P[,S])] o o o DECIMAL x5
DEC [(P[,S])] o o x DECIMAL x5
INTEGER o o o INTEGER int
INT o o o INTEGER int
SMALLINT o o o SMALLINT short
BIGINT x x x BIGINT long
FLOAT [(P)] o o o FLOAT double/float
REAL o o o REAL float
DOUBLE PRECISION o o o DOUBLE double
BOOLEAN x o x BOOLEAN boolean
DATE o o o DATE x
TIME [(P)]2 o o o TIME x
TIMESTAMP [(P)]2 o o o TIMESTAMP x
INTERVAL ... 3 o o o x x
x BIT [(P)] o o BIT? bit?
x BIT VARYING [(P)] o o BIT? bit?
x x x STC x x
x x x x x floatComplex
x x x x x doubleComplex
x x x x x unicodeChar

1 The syntax for sizes of large objects is actually somewhat different from the "[(P)]" applicable to simpler data types.
2 The syntax for sizes of TIME and TIMESTAMP is actually somewhat different from the "[(P)]" applicable to simpler data types.
3 See the SQL 2003 grammar for precise specification of INTERVAL type.
4 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.
5 Decimal might be mapped to floats or doubles in a result type, but have different semantics for mathematical operations etc.
6 Following Mark's suggestion on the mailing list.


META FILEATTACHMENT attr="" comment="" date="1237791864" name="adqltypes.txt" path="adql types.txt" size="13537" user="GerardLemson" version="1.1"

Revision 62009-03-24 - GerardLemson

 
META TOPICPARENT name="GerardLemsonTAP_031"
Changed:
<
<
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.
>
>
Overview of SQL datataypes based on SQL 2003 (as it seems most extensive). "o" in column implies it exists also in other SQL versions, is anticipated by ADQL through its list reserved words. The columns JDBC and VOTable give the mapping to those two type systems. A "[(P[,S])]" after a datatypeps indicates that a precision (P) and possibly a scale(S) can be provided.
Deleted:
<
<
a "[(P[,S])]" after a datatypeps indicates that a precision (P) and possibly a scale(S) can be provided.
 
Changed:
<
<
For info on database support this look at JVO presentation during Victoria 2006 interop. Also various JDBC mapping tables such as this.
>
>
For info on database support look at JVO presentation during Victoria 2006 interop. Also various JDBC mapping tables such as this.
 
Deleted:
<
<
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.

 
SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type4 Sort VOTable 1.2 (beta) Sort
CHARACTER [(P)] o o o CHAR char
CHAR [(P)] o o o CHAR char
CHARACTER VARYING[(P)] o o o VARCHAR char
CHAR VARYING [(P)] o o o VARCHAR char
VARCHAR [(P)] o o o VARCHAR char
CHARACTER LARGE OBJECT [(P)]1 x o x CLOB char (?)
CHAR LARGE OBJECT [(P)]1 x o x CLOB char (?)
CLOB [(P)]1 x o x CLOB char (?)
NATIONAL CHARACTER [(P)] o o o NCHAR char
NATIONAL CHAR [(P)] o o o NCHAR char
NCHAR [(P)] o o o NCHAR char
NATIONAL CHARACTER VARYING[(P)] o o o NVARCHAR char
NATIONAL CHAR VARYING [(P)] o o o NVARCHAR char
NCHAR VARYING [(P)] o o o NVARCHAR char
NATIONAL CHARACTER LARGE OBJECT [(P)]1 x o x NCLOB char (?)
NCHAR LARGE OBJECT [(P)]1 x o x NCLOB char (?)
NCLOB [(P)]1 x o x NCLOB char (?)
Changed:
<
<
BINARY LARGE OBJECT [(P)]1 x o x BLOB x
BLOB [(P)]1 x o x BLOB x
>
>
BINARY LARGE OBJECT [(P)]1 x o x BLOB unsignedByte6
BLOB [(P)]1 x o x BLOB unsignedByte6
 
NUMERIC [(P[,S])] o o o NUMERIC x5
DECIMAL [(P[,S])] o o o DECIMAL x5
DEC [(P[,S])] o o x DECIMAL x5
INTEGER o o o INTEGER int
INT o o o INTEGER int
SMALLINT o o o SMALLINT short
BIGINT x x x BIGINT long
FLOAT [(P)] o o o FLOAT double/float
REAL o o o REAL float
DOUBLE PRECISION o o o DOUBLE double
BOOLEAN x o x BOOLEAN boolean
DATE o o o DATE x
TIME [(P)]2 o o o TIME x
TIMESTAMP [(P)]2 o o o TIMESTAMP x
INTERVAL ... 3 o o o x x
x BIT [(P)] o o BIT? bit?
x BIT VARYING [(P)] o o BIT? bit?
x x x STC x x
Added:
>
>
x x x x x floatComplex
x x x x x doubleComplex
x x x x x unicodeChar
 
Added:
>
>
  1 The syntax for sizes of large objects is actually somewhat different from the "[(P)]" applicable to simpler data types.
2 The syntax for sizes of TIME and TIMESTAMP is actually somewhat different from the "[(P)]" applicable to simpler data types.
3 See the SQL 2003 grammar for precise specification of INTERVAL type.
4 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.
5 Decimal might be mapped to floats or doubles in a result type, but have different semantics for mathematical operations etc.
Changed:
<
<
>
>
6 Following Mark's suggestion on the mailing list.
 
<--  
-->

META FILEATTACHMENT attr="" comment="" date="1237791864" name="adqltypes.txt" path="adql types.txt" size="13537" user="GerardLemson" version="1.1"

Revision 52009-03-24 - GerardLemson

 
META TOPICPARENT name="GerardLemsonTAP_031"
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.
Changed:
<
<
For info on database support this look at JVO presentation during Victoria 2006 interop. Also various JDBC mapping tables such as this.
>
>
For info on database support this look at JVO presentation during Victoria 2006 interop. Also various JDBC mapping tables such as 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.

SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type4 Sort VOTable 1.2 (beta) Sort
CHARACTER [(P)] o o o CHAR char
CHAR [(P)] o o o CHAR char
CHARACTER VARYING[(P)] o o o VARCHAR char
CHAR VARYING [(P)] o o o VARCHAR char
VARCHAR [(P)] o o o VARCHAR char
CHARACTER LARGE OBJECT [(P)]1 x o x CLOB char (?)
CHAR LARGE OBJECT [(P)]1 x o x CLOB char (?)
CLOB [(P)]1 x o x CLOB char (?)
NATIONAL CHARACTER [(P)] o o o NCHAR char
NATIONAL CHAR [(P)] o o o NCHAR char
NCHAR [(P)] o o o NCHAR char
NATIONAL CHARACTER VARYING[(P)] o o o NVARCHAR char
NATIONAL CHAR VARYING [(P)] o o o NVARCHAR char
NCHAR VARYING [(P)] o o o NVARCHAR char
NATIONAL CHARACTER LARGE OBJECT [(P)]1 x o x NCLOB char (?)
NCHAR LARGE OBJECT [(P)]1 x o x NCLOB char (?)
NCLOB [(P)]1 x o x NCLOB char (?)
BINARY LARGE OBJECT [(P)]1 x o x BLOB x
BLOB [(P)]1 x o x BLOB x
NUMERIC [(P[,S])] o o o NUMERIC x5
DECIMAL [(P[,S])] o o o DECIMAL x5
DEC [(P[,S])] o o x DECIMAL x5
INTEGER o o o INTEGER int
INT o o o INTEGER int
SMALLINT o o o SMALLINT short
BIGINT x x x BIGINT long
FLOAT [(P)] o o o FLOAT double/float
REAL o o o REAL float
DOUBLE PRECISION o o o DOUBLE double
BOOLEAN x o x BOOLEAN boolean
DATE o o o DATE x
TIME [(P)]2 o o o TIME x
TIMESTAMP [(P)]2 o o o TIMESTAMP x
INTERVAL ... 3 o o o x x
x BIT [(P)] o o BIT? bit?
x BIT VARYING [(P)] o o BIT? bit?
Changed:
<
<
>
>
x x x STC x x
 

1 The syntax for sizes of large objects is actually somewhat different from the "[(P)]" applicable to simpler data types.
2 The syntax for sizes of TIME and TIMESTAMP is actually somewhat different from the "[(P)]" applicable to simpler data types.
3 See the SQL 2003 grammar for precise specification of INTERVAL type.
4 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.
5 Decimal might be mapped to floats or doubles in a result type, but have different semantics for mathematical operations etc.


<--  
-->

META FILEATTACHMENT attr="" comment="" date="1237791864" name="adqltypes.txt" path="adql types.txt" size="13537" user="GerardLemson" version="1.1"

Revision 42009-03-23 - GerardLemson

 
META TOPICPARENT name="GerardLemsonTAP_031"
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 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.

SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type4 Sort VOTable 1.2 (beta) Sort
Changed:
<
<
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)]1 x o x CLOB  
CHAR LARGE OBJECT [(P)]1 x o x CLOB  
CLOB [(P)]1 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)]1 x o x NCLOB  
NCHAR LARGE OBJECT [(P)]1 x o x NCLOB  
NCLOB [(P)]1 x o x NCLOB  
BINARY LARGE OBJECT [(P)]1 x o x BLOB  
BLOB [(P)]1 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)]2 o o o TIME  
TIMESTAMP [(P)]2 o o o TIMESTAMP  
INTERVAL ... 3 o o o x  
x BIT [(P)] o o BIT?  
x BIT VARYING [(P)] o o BIT?  
>
>
CHARACTER [(P)] o o o CHAR char
CHAR [(P)] o o o CHAR char
CHARACTER VARYING[(P)] o o o VARCHAR char
CHAR VARYING [(P)] o o o VARCHAR char
VARCHAR [(P)] o o o VARCHAR char
CHARACTER LARGE OBJECT [(P)]1 x o x CLOB char (?)
CHAR LARGE OBJECT [(P)]1 x o x CLOB char (?)
CLOB [(P)]1 x o x CLOB char (?)
NATIONAL CHARACTER [(P)] o o o NCHAR char
NATIONAL CHAR [(P)] o o o NCHAR char
NCHAR [(P)] o o o NCHAR char
NATIONAL CHARACTER VARYING[(P)] o o o NVARCHAR char
NATIONAL CHAR VARYING [(P)] o o o NVARCHAR char
NCHAR VARYING [(P)] o o o NVARCHAR char
NATIONAL CHARACTER LARGE OBJECT [(P)]1 x o x NCLOB char (?)
NCHAR LARGE OBJECT [(P)]1 x o x NCLOB char (?)
NCLOB [(P)]1 x o x NCLOB char (?)
BINARY LARGE OBJECT [(P)]1 x o x BLOB x
BLOB [(P)]1 x o x BLOB x
NUMERIC [(P[,S])] o o o NUMERIC x5
DECIMAL [(P[,S])] o o o DECIMAL x5
DEC [(P[,S])] o o x DECIMAL x5
INTEGER o o o INTEGER int
INT o o o INTEGER int
SMALLINT o o o SMALLINT short
BIGINT x x x BIGINT long
FLOAT [(P)] o o o FLOAT double/float
REAL o o o REAL float
DOUBLE PRECISION o o o DOUBLE double
BOOLEAN x o x BOOLEAN boolean
DATE o o o DATE x
TIME [(P)]2 o o o TIME x
TIMESTAMP [(P)]2 o o o TIMESTAMP x
INTERVAL ... 3 o o o x x
x BIT [(P)] o o BIT? bit?
x BIT VARYING [(P)] o o BIT? bit?
 

1 The syntax for sizes of large objects is actually somewhat different from the "[(P)]" applicable to simpler data types.
2 The syntax for sizes of TIME and TIMESTAMP is actually somewhat different from the "[(P)]" applicable to simpler data types.
3 See the SQL 2003 grammar for precise specification of INTERVAL type.

Changed:
<
<
4 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.
>
>
4 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.
Added:
>
>
5 Decimal might be mapped to floats or doubles in a result type, but have different semantics for mathematical operations etc.
 
<--  
-->

META FILEATTACHMENT attr="" comment="" date="1237791864" name="adqltypes.txt" path="adql types.txt" size="13537" user="GerardLemson" version="1.1"

Revision 32009-03-23 - GerardLemson

 
META TOPICPARENT name="GerardLemsonTAP_031"
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 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.

Changed:
<
<
SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type Sort VOTable 1.2 (beta) Sort
CHARACTER [(P)] o o o    
CHAR [(P)] o o o    
CHARACTER VARYING[(P)] o o o    
CHAR VARYING [(P)] o o o    
VARCHAR [(P)] o o o    
CHARACTER LARGE OBJECT [(P)]1 x o x    
CHAR LARGE OBJECT [(P)]1 x o x    
CLOB [(P)]1 x o x    
NATIONAL CHARACTER [(P)] o o o    
NATIONAL CHAR [(P)] o o o    
NCHAR [(P)] o o o    
NATIONAL CHARACTER VARYING[(P)] o o o    
NATIONAL CHAR VARYING [(P)] o o o    
NCHAR VARYING [(P)] o o o    
NATIONAL CHARACTER LARGE OBJECT [(P)]1 x o x    
NCHAR LARGE OBJECT [(P)]1 x o x    
NCLOB [(P)]1 x o x    
BINARY LARGE OBJECT [(P)]1 x o x    
BLOB [(P)]1 x o x    
NUMERIC [(P[,S])] o o o    
DECIMAL [(P[,S])] o o o    
DEC [(P[,S])] o o x    
INTEGER o o o    
INT o o o    
SMALLINT o o o    
BIGINT x x x    
FLOAT [(P)] o o o    
REAL o o o    
DOUBLE PRECISION o o o    
BOOLEAN x o x    
DATE o o o    
TIME [(P)]2 o o o    
TIMESTAMP [(P)]2 o o o    
INTERVAL ... 3 o o o    
x BIT [(P)] o o    
x BIT VARYING [(P)] o o    
>
>
SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type4 Sort VOTable 1.2 (beta) Sort
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)]1 x o x CLOB  
CHAR LARGE OBJECT [(P)]1 x o x CLOB  
CLOB [(P)]1 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)]1 x o x NCLOB  
NCHAR LARGE OBJECT [(P)]1 x o x NCLOB  
NCLOB [(P)]1 x o x NCLOB  
BINARY LARGE OBJECT [(P)]1 x o x BLOB  
BLOB [(P)]1 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)]2 o o o TIME  
TIMESTAMP [(P)]2 o o o TIMESTAMP  
INTERVAL ... 3 o o o x  
x BIT [(P)] o o BIT?  
x BIT VARYING [(P)] o o BIT?  
 

1 The syntax for sizes of large objects is actually somewhat different from the "[(P)]" applicable to simpler data types.
2 The syntax for sizes of TIME and TIMESTAMP is actually somewhat different from the "[(P)]" applicable to simpler data types.

Changed:
<
<
3 See the SQL 2003 grammar for precise specification of INTERVAL type.
>
>
3 See the SQL 2003 grammar for precise specification of INTERVAL type.
4 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.
 
<--  
-->

META FILEATTACHMENT attr="" comment="" date="1237791864" name="adqltypes.txt" path="adql types.txt" size="13537" user="GerardLemson" version="1.1"

Revision 22009-03-23 - GerardLemson

 
META TOPICPARENT name="GerardLemsonTAP_031"
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.
Changed:
<
<
For info on database support this look at JVO presentation during Victoria 2006 interop.
>
>
For info on database support this look at JVO presentation during Victoria 2006 interop. Also various JDBC mapping tables such as 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.

Changed:
<
<
SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type Sort VOTable 1.2 (beta) Sort
CHARACTER [(P)]          
CHAR [(P)]          
CHARACTER VARYING[(P)]          
CHAR VARYING [(P)]          
VARCHAR [(P)]          
CHARACTER LARGE OBJECT [(P)]1          
CHAR LARGE OBJECT [(P)]1          
CLOB [(P)]1          
NATIONAL CHARACTER [(P)]          
NATIONAL CHAR [(P)]          
NCHAR [(P)]          
NATIONAL CHARACTER VARYING[(P)]          
NATIONAL CHAR VARYING [(P)]          
NCHAR VARYING [(P)]          
NATIONAL CHARACTER LARGE OBJECT [(P)]1          
NCHAR LARGE OBJECT [(P)]1          
NCLOB [(P)]1          
BINARY LARGE OBJECT [(P)]1          
BLOB [(P)]1          
NUMERIC [(P[,S])]          
DECIMAL [(P[,S])]          
DEC [(P[,S])]          
INTEGER          
INT          
SMALLINT          
FLOAT [(P)]          
REAL          
DOUBLE PRECISION          
BOOLEAN          
DATE          
TIME [(P)]2          
TIMESTAMP [(P)]2          
INTERVAL ... 3          
  BIT [(P)] x x    
  BIT VARYING [(P)] x x    
>
>
SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type Sort VOTable 1.2 (beta) Sort
CHARACTER [(P)] o o o    
CHAR [(P)] o o o    
CHARACTER VARYING[(P)] o o o    
CHAR VARYING [(P)] o o o    
VARCHAR [(P)] o o o    
CHARACTER LARGE OBJECT [(P)]1 x o x    
CHAR LARGE OBJECT [(P)]1 x o x    
CLOB [(P)]1 x o x    
NATIONAL CHARACTER [(P)] o o o    
NATIONAL CHAR [(P)] o o o    
NCHAR [(P)] o o o    
NATIONAL CHARACTER VARYING[(P)] o o o    
NATIONAL CHAR VARYING [(P)] o o o    
NCHAR VARYING [(P)] o o o    
NATIONAL CHARACTER LARGE OBJECT [(P)]1 x o x    
NCHAR LARGE OBJECT [(P)]1 x o x    
NCLOB [(P)]1 x o x    
BINARY LARGE OBJECT [(P)]1 x o x    
BLOB [(P)]1 x o x    
NUMERIC [(P[,S])] o o o    
DECIMAL [(P[,S])] o o o    
DEC [(P[,S])] o o x    
INTEGER o o o    
INT o o o    
SMALLINT o o o    
BIGINT x x x    
FLOAT [(P)] o o o    
REAL o o o    
DOUBLE PRECISION o o o    
BOOLEAN x o x    
DATE o o o    
TIME [(P)]2 o o o    
TIMESTAMP [(P)]2 o o o    
INTERVAL ... 3 o o o    
x BIT [(P)] o o    
Added:
>
>
x BIT VARYING [(P)] o o    
 

1 The syntax for sizes of large objects is actually somewhat different from the "[(P)]" applicable to simpler data types.
2 The syntax for sizes of TIME and TIMESTAMP is actually somewhat different from the "[(P)]" applicable to simpler data types.
3 See the SQL 2003 grammar for precise specification of INTERVAL type.


<--  
-->

META FILEATTACHMENT attr="" comment="" date="1237791864" name="adqltypes.txt" path="adql types.txt" size="13537" user="GerardLemson" version="1.1"

Revision 12009-03-23 - GerardLemson

 
META TOPICPARENT name="GerardLemsonTAP_031"
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.

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.

SQL 2003 Sort SQL 92 Sort SQL 99 Sort ADQL 2.0 Sort JDBC type Sort VOTable 1.2 (beta) Sort
CHARACTER [(P)]          
CHAR [(P)]          
CHARACTER VARYING[(P)]          
CHAR VARYING [(P)]          
VARCHAR [(P)]          
CHARACTER LARGE OBJECT [(P)]1          
CHAR LARGE OBJECT [(P)]1          
CLOB [(P)]1          
NATIONAL CHARACTER [(P)]          
NATIONAL CHAR [(P)]          
NCHAR [(P)]          
NATIONAL CHARACTER VARYING[(P)]          
NATIONAL CHAR VARYING [(P)]          
NCHAR VARYING [(P)]          
NATIONAL CHARACTER LARGE OBJECT [(P)]1          
NCHAR LARGE OBJECT [(P)]1          
NCLOB [(P)]1          
BINARY LARGE OBJECT [(P)]1          
BLOB [(P)]1          
NUMERIC [(P[,S])]          
DECIMAL [(P[,S])]          
DEC [(P[,S])]          
INTEGER          
INT          
SMALLINT          
FLOAT [(P)]          
REAL          
DOUBLE PRECISION          
BOOLEAN          
DATE          
TIME [(P)]2          
TIMESTAMP [(P)]2          
INTERVAL ... 3          
  BIT [(P)] x x    
  BIT VARYING [(P)] x x    

1 The syntax for sizes of large objects is actually somewhat different from the "[(P)]" applicable to simpler data types.
2 The syntax for sizes of TIME and TIMESTAMP is actually somewhat different from the "[(P)]" applicable to simpler data types.
3 See the SQL 2003 grammar for precise specification of INTERVAL type.


<--  
-->

META FILEATTACHMENT attr="" comment="" date="1237791864" name="adqltypes.txt" path="adql types.txt" size="13537" user="GerardLemson" version="1.1"
 
This site is powered by the TWiki collaboration platform Powered by Perl This site is powered by the TWiki collaboration platformCopyright © 2008-2022 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback