LibreOffice
LibreOffice 24.8 SDK API Reference
 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Pages
Variables
com::sun::star::sdbc::DataType Constant Group Referencepublished

These constants are used to specify database data types which are used to identify the generic SQL types. More...

Variables

const long BIT = -7
 
const long TINYINT = -6
 
const long SMALLINT = 5
 
const long INTEGER = 4
 
const long BIGINT = -5
 
const long FLOAT = 6
 
const long REAL = 7
 
const long DOUBLE = 8
 
const long NUMERIC = 2
 
const long DECIMAL = 3
 
const long CHAR = 1
 
const long VARCHAR = 12
 
const long LONGVARCHAR = -1
 
const long DATE = 91
 
const long TIME = 92
 
const long TIMESTAMP = 93
 
const long BINARY = -2
 
const long VARBINARY = -3
 
const long LONGVARBINARY = -4
 
const long SQLNULL = 0
 
const long OTHER = 1111
 indicates that the SQL type is database-specific and gets mapped to an object that can be accessed via the method com::sun::star::sdbc::XRow::getObject(). More...
 
const long OBJECT = 2000
 indicates a type which is represented by an object which implements this type. More...
 
const long DISTINCT = 2001
 describes a type based on a built-in type. More...
 
const long STRUCT = 2002
 indicates a type consisting of attributes that may be any type. More...
 
const long ARRAY = 2003
 indicates a type representing an SQL ARRAY. More...
 
const long BLOB = 2004
 indicates a type representing an SQL Binary Large Object. More...
 
const long CLOB = 2005
 indicates a type representing an SQL Character Large Object. More...
 
const long REF = 2006
 indicates a type representing an SQL REF, a referencing type. More...
 
const long BOOLEAN = 16
 identifies the generic SQL type BOOLEAN. More...
 
const long DATALINK = 70
 indicates a type representing an SQL DATALINK. More...
 
const long ROWID = -8
 indicates a type representing an SQL ROWID. More...
 
const long NCHAR = -15
 indicates a type representing an SQL NCHAR. More...
 
const long NVARCHAR = -9
 indicates a type representing an SQL NVARCHAR. More...
 
const long LONGNVARCHAR = -16
 indicates a type representing an SQL LONGNVARCHAR. More...
 
const long NCLOB = 2011
 indicates a type representing an SQL NCLOB. More...
 
const long SQLXML = 2009
 indicates a type representing an SQL XML. More...
 
const long REF_CURSOR = 2012
 indicates a type representing an SQL REF CURSOR. More...
 
const long TIME_WITH_TIMEZONE = 2013
 indicates a type representing an SQL TIME WITH TIMEZONE. More...
 
const long TIMESTAMP_WITH_TIMEZONE = 2014
 indicates a type representing an SQL TIMESTAMP WITH TIMEZONE. More...
 

Detailed Description

These constants are used to specify database data types which are used to identify the generic SQL types.

The definition is based on JDBC 3.0.

The actual type constant values are equivalent to those in the X/Open CLI.

Precise information about the specific types can be got from XDatabaseMetaData::getTypeInfo().

Variable Documentation

const long ARRAY = 2003

indicates a type representing an SQL ARRAY.

const long BIGINT = -5
const long BINARY = -2
const long BIT = -7
const long BLOB = 2004

indicates a type representing an SQL Binary Large Object.

const long BOOLEAN = 16

identifies the generic SQL type BOOLEAN.

Since
OOo 2.0
const long CHAR = 1
const long CLOB = 2005

indicates a type representing an SQL Character Large Object.

const long DATALINK = 70

indicates a type representing an SQL DATALINK.

Since
LibreOffice 24.2
const long DATE = 91
const long DECIMAL = 3
const long DISTINCT = 2001

describes a type based on a built-in type.

It is a user-defined data type (UDT).

const long DOUBLE = 8
const long FLOAT = 6
const long INTEGER = 4
const long LONGNVARCHAR = -16

indicates a type representing an SQL LONGNVARCHAR.

Since
LibreOffice 24.2
const long LONGVARBINARY = -4
const long LONGVARCHAR = -1
const long NCHAR = -15

indicates a type representing an SQL NCHAR.

Since
LibreOffice 24.2
const long NCLOB = 2011

indicates a type representing an SQL NCLOB.

Since
LibreOffice 24.2
const long NUMERIC = 2
const long NVARCHAR = -9

indicates a type representing an SQL NVARCHAR.

Since
LibreOffice 24.2
const long OBJECT = 2000

indicates a type which is represented by an object which implements this type.

const long OTHER = 1111

indicates that the SQL type is database-specific and gets mapped to an object that can be accessed via the method com::sun::star::sdbc::XRow::getObject().

const long REAL = 7
const long REF = 2006

indicates a type representing an SQL REF, a referencing type.

const long REF_CURSOR = 2012

indicates a type representing an SQL REF CURSOR.

Since
LibreOffice 24.2
const long ROWID = -8

indicates a type representing an SQL ROWID.

Since
LibreOffice 24.2
const long SMALLINT = 5
const long SQLNULL = 0
const long SQLXML = 2009

indicates a type representing an SQL XML.

Since
LibreOffice 24.2
const long STRUCT = 2002

indicates a type consisting of attributes that may be any type.

It is a user-defined data type (UDT).

const long TIME = 92
const long TIME_WITH_TIMEZONE = 2013

indicates a type representing an SQL TIME WITH TIMEZONE.

Since
LibreOffice 24.2
const long TIMESTAMP = 93
const long TIMESTAMP_WITH_TIMEZONE = 2014

indicates a type representing an SQL TIMESTAMP WITH TIMEZONE.

Since
LibreOffice 24.2
const long TINYINT = -6
const long VARBINARY = -3
const long VARCHAR = 12