Documentation
¶
CHARACTER
CHARACTER
VARCHAR
VARCHAR'('INTNUM')'
NVARCHAR
NVARCHAR'('INTNUM')'
CHAR'('INTNUM')'
NUMERIC
NUMERIC
NUMERIC'('INTNUM')'
NUMERIC'('INTNUM','INTNUM')'
DECIMAL
DECIMAL
DECIMAL'('INTNUM')'
DECIMAL'('INTNUM','INTNUM')'
INTEGER
INT
INTEGER
SMALLINT
FLOAT
FLOAT
FLOAT'('INTNUM')'
REAL
REAL
DOUBLE PRECISION
LONG VARCHAR
BLOB data
VARBINARY [( precision )]
Binary data
LONG VARBINARY
Binary BLOB data
TIMESTAMP
TIMESTAMP
DATETIME
TIME
DATE
<UDT>
User Defined Type with varbinary-like size properties.
LONG <UDT>
User Defined Type with LONG varbinary-like size properties.
LONG XML
LONG XML BLOB-like data type.
Note:
User Defined Types can be created from native or external types,
composites or classes from any hosted language such as Java or
.Net. Any User Defined Type can be used to define a column in a
CREATE TABLE statement.
This HTML5 document contains 16 embedded RDF statements represented using HTML+Microdata notation.
The embedded RDF content will be recognized by any processor of HTML5 Microdata.
Prefix
Namespace IRI
schema
http://schema.org/
n3
http://docs.openlinksw.com/virtuoso/sqlrefdatatypes/
n5
http://creativecommons.org/licenses/by/4.0/deed.
rdf
http://www.w3.org/1999/02/22-rdf-syntax-ns#
n4
http://www.openlinksw.com/#
xsdh
http://www.w3.org/2001/XMLSchema#
Subject Item
n3:
rdf:type
schema:APIReference
schema:TechArticle
schema:name
9.1. Datatypes
schema:copyrightHolder
_:vb81756
schema:datePublished
2016-09-09 16:16:54
schema:headline
9.1. Datatypes
schema:keywords
OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data
schema:license
n5:en_US
schema:publisher
_:vb81755
schema:url
n3:
Subject Item
_:vb81755
rdf:type
schema:Organization
schema:name
OpenLink Software
schema:url
n4:this
Subject Item
_:vb81756
rdf:type
schema:Organization
schema:name
OpenLink Software
schema:url
n4:this
This HTML document contains 16 embedded RDF statements represented using (X)HTML+RDFa notation.
The embedded RDF content will be recognized by any processor of (X)HTML+RDFa.
Namespace Prefix
Namespace URI
xmlns:schema
http://schema.org/
xmlns:n3
http://docs.openlinksw.com/virtuoso/sqlrefdatatypes/
xmlns:n5
http://creativecommons.org/licenses/by/4.0/deed.
xmlns:rdf
http://www.w3.org/1999/02/22-rdf-syntax-ns#
xmlns:n4
http://www.openlinksw.com/#
xmlns:xsdh
http://www.w3.org/2001/XMLSchema#
Subject
Predicate
Object
n3:
rdf:type
schema:APIReference
n3:
rdf:type
schema:TechArticle
n3:
schema:name
9.1.ÃÂ Datatypes
n3:
schema:copyrightHolder
_:vb81756
n3:
schema:datePublished
2016-09-09 16:16:54
n3:
schema:headline
9.1.ÃÂ Datatypes
n3:
schema:keywords
OpenLink,Virtuoso,database,RDBMS,relational,SQL,RDF,triple store,linked data,linked open data,Big Data
n3:
schema:license
n5:en_US
n3:
schema:publisher
_:vb81755
n3:
schema:url
n3:
_:vb81755
rdf:type
schema:Organization
_:vb81755
schema:name
OpenLink Software
_:vb81755
schema:url
n4:this
_:vb81756
rdf:type
schema:Organization
_:vb81756
schema:name
OpenLink Software
_:vb81756
schema:url
n4:this