Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: com :: sun :: star :: sdbc ::

constants group DataType
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 specfic types can be got from XDatabaseMetaData::getTypeInfo() .


Constants
BIT  
TINYINT  
SMALLINT  
INTEGER  
BIGINT  
FLOAT  
REAL  
DOUBLE  
NUMERIC  
DECIMAL  
CHAR  
VARCHAR  
LONGVARCHAR  
DATE  
TIME  
TIMESTAMP  
BINARY  
VARBINARY  
LONGVARBINARY  
SQLNULL  
OTHER indicates that the SQL type is database-specific and gets mapped to an object that can be accessed via the method XRow::getObject() .  
OBJECT indicates a type which is represented by an object which implements this type.  
DISTINCT describes a type based on a built-in type. It is a user-defined data type (UDT).  
STRUCT indicates a type consisting of attributes that may be any type. It is a user-defined data type (UDT).  
ARRAY indicates a type representing an SQL ARRAY.  
BLOB indicates a type representing an SQL Binary Large Object.  
CLOB indicates a type representing an SQL Character Large Object.  
REF indicates a type representing an SQL REF, a referencing type.  
BOOLEAN identifies the generic SQL type * BOOLEAN. * *  
Constants' Details
BIT
const long BIT = -7;
TINYINT
const long TINYINT = -6;
SMALLINT
const long SMALLINT = 5;
INTEGER
const long INTEGER = 4;
BIGINT
const long BIGINT = -5;
FLOAT
const long FLOAT = 6;
REAL
const long REAL = 7;
DOUBLE
const long DOUBLE = 8;
NUMERIC
const long NUMERIC = 2;
DECIMAL
const long DECIMAL = 3;
CHAR
const long CHAR = 1;
VARCHAR
const long VARCHAR = 12;
LONGVARCHAR
const long LONGVARCHAR = -1;
DATE
const long DATE = 91;
TIME
const long TIME = 92;
TIMESTAMP
const long TIMESTAMP = 93;
BINARY
const long BINARY = -2;
VARBINARY
const long VARBINARY = -3;
LONGVARBINARY
const long LONGVARBINARY = -4;
SQLNULL
const long SQLNULL = 0;
OTHER
const long OTHER = 1111;
Description
indicates that the SQL type is database-specific and gets mapped to an object that can be accessed via the method XRow::getObject() .
OBJECT
const long OBJECT = 2000;
Description
indicates a type which is represented by an object which implements this type.
DISTINCT
const long DISTINCT = 2001;
Description
describes a type based on a built-in type. It is a user-defined data type (UDT).
STRUCT
const long STRUCT = 2002;
Description
indicates a type consisting of attributes that may be any type. It is a user-defined data type (UDT).
ARRAY
const long ARRAY = 2003;
Description
indicates a type representing an SQL ARRAY.
BLOB
const long BLOB = 2004;
Description
indicates a type representing an SQL Binary Large Object.
CLOB
const long CLOB = 2005;
Description
indicates a type representing an SQL Character Large Object.
REF
const long REF = 2006;
Description
indicates a type representing an SQL REF, a referencing type.
BOOLEAN
const long BOOLEAN = 16;
Description
identifies the generic SQL type * BOOLEAN. * *
Since
OOo 2.0
Top of Page

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.