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

◆ ARRAY

const long ARRAY = 2003

indicates a type representing an SQL ARRAY.

◆ BIGINT

const long BIGINT = -5

◆ BINARY

const long BINARY = -2

◆ BIT

const long BIT = -7

◆ BLOB

const long BLOB = 2004

indicates a type representing an SQL Binary Large Object.

◆ BOOLEAN

const long BOOLEAN = 16

identifies the generic SQL type BOOLEAN.

Since: OOo 2.0

◆ CHAR

const long CHAR = 1

◆ CLOB

const long CLOB = 2005

indicates a type representing an SQL Character Large Object.

◆ DATALINK

const long DATALINK = 70

indicates a type representing an SQL DATALINK.

Since: LibreOffice 24.2

◆ DATE

const long DATE = 91

◆ DECIMAL

const long DECIMAL = 3

◆ DISTINCT

const long DISTINCT = 2001

describes a type based on a built-in type.

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

◆ DOUBLE

const long DOUBLE = 8

◆ FLOAT

const long FLOAT = 6

◆ INTEGER

const long INTEGER = 4

◆ LONGNVARCHAR

const long LONGNVARCHAR = -16

indicates a type representing an SQL LONGNVARCHAR.

Since: LibreOffice 24.2

◆ LONGVARBINARY

const long LONGVARBINARY = -4

◆ LONGVARCHAR

const long LONGVARCHAR = -1

◆ NCHAR

const long NCHAR = -15

indicates a type representing an SQL NCHAR.

Since: LibreOffice 24.2

◆ NCLOB

const long NCLOB = 2011

indicates a type representing an SQL NCLOB.

Since: LibreOffice 24.2

◆ NUMERIC

const long NUMERIC = 2

◆ NVARCHAR

const long NVARCHAR = -9

indicates a type representing an SQL NVARCHAR.

Since: LibreOffice 24.2

◆ OBJECT

const long OBJECT = 2000

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

◆ OTHER

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().

◆ REAL

const long REAL = 7

◆ REF

const long REF = 2006

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

◆ REF_CURSOR

const long REF_CURSOR = 2012

indicates a type representing an SQL REF CURSOR.

Since: LibreOffice 24.2

◆ ROWID

const long ROWID = -8

indicates a type representing an SQL ROWID.

Since: LibreOffice 24.2

◆ SMALLINT

const long SMALLINT = 5

◆ SQLNULL

const long SQLNULL = 0

◆ SQLXML

const long SQLXML = 2009

indicates a type representing an SQL XML.

Since: LibreOffice 24.2

◆ STRUCT

const long STRUCT = 2002

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