Mimer JDBC/MIDP 2.12

com.mimer.jdbc
Class Types

java.lang.Object
  |
  +--com.mimer.jdbc.Types

public class Types
extends java.lang.Object

Constants referring to server SQL datatypes.


Field Summary
static int BIGINT
          The SQL datatype BIGINT.
static int BINARY
          The SQL standard does not support a BINARY data type.
static int BIT
          This constant identifies the SQL datatype BIT.
static int BLOB
          The SQL data type BINARY LARGE OBJECT (BLOB).
static int CHAR
          The SQL datatype CHARACTER.
static int CLOB
          The SQL data type CHARACTER LARGE OBJECT (BLOB).
static int DATE
          The SQL datatype DATE.
static int DECIMAL
          The SQL datatype DECIMAL.
static int DOUBLE
          The SQL datatype DOUBLE PRECISION.
static int FLOAT
          The SQL datatype FLOAT.
static int INTEGER
          The SQL datatype INTEGER.
static int LONGVARBINARY
          A long BINARY VARYING data type.
static int LONGVARCHAR
          A long CHARACTER VARYING data type.
static int NULL
           
static int NUMERIC
          The SQL datatype NUMERIC.
static int OTHER
           
static int REAL
          The SQL datatype REAL.
static int SMALLINT
          The SQL datatype SMALLINT.
static int TIME
          The SQL datatype TIME.
static int TIMESTAMP
          The SQL datatype TIMESTAMP.
static int TINYINT
          This constant identifies a SQL datatype TINYINT.
static int VARBINARY
          The SQL standard does not support a BINARY data type.
static int VARCHAR
          The SQL datatype CHARACTER VARYING.
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Field Detail

BIGINT

public static final int BIGINT
The SQL datatype BIGINT. This JDBC type code may also correspond to the Mimer specific datatype INTEGER(n), where n>=10.

See Also:
Constant Field Values

BINARY

public static final int BINARY
The SQL standard does not support a BINARY data type. Mimer SQL implements a BINARY data type whose length is at most 15000 bytes.

See Also:
Constant Field Values

BIT

public static final int BIT
This constant identifies the SQL datatype BIT. This type was introduced in the SQL-99 standard but will be removed in SQL-2003. For this reason, Mimer SQL has no native bit datatype, but always has a preinstalled system domain (ODBC.BIT) for this type.

See Also:
Constant Field Values

BLOB

public static final int BLOB
The SQL data type BINARY LARGE OBJECT (BLOB). Mimer supports BLOB:s of up to 8 TB in length.

See Also:
Constant Field Values

CHAR

public static final int CHAR
The SQL datatype CHARACTER. In Mimer SQL this corresponds to a 8-bit per character string of characters, of up to 15000 characters.

See Also:
Constant Field Values

CLOB

public static final int CLOB
The SQL data type CHARACTER LARGE OBJECT (BLOB). Mimer supports CLOB:s of up to 8 TB in length. Mimer SQL also supports NATIONAL CHARACTER LARGE OBJECTS for Unicode data. This code represents both of tehse server data types.

See Also:
Constant Field Values

DATE

public static final int DATE
The SQL datatype DATE.

See Also:
Constant Field Values

DECIMAL

public static final int DECIMAL
The SQL datatype DECIMAL.

See Also:
Constant Field Values

DOUBLE

public static final int DOUBLE
The SQL datatype DOUBLE PRECISION.

See Also:
Constant Field Values

FLOAT

public static final int FLOAT
The SQL datatype FLOAT. This JDBC type code may also correspond to the Mimer specific datatype FLOAT(n).

See Also:
Constant Field Values

INTEGER

public static final int INTEGER
The SQL datatype INTEGER. This JDBC type code may also correspond to the Mimer specific datatype INTEGER(n), where 4<=n<10.

See Also:
Constant Field Values

LONGVARBINARY

public static final int LONGVARBINARY
A long BINARY VARYING data type. In Mimer SQL this corresponds to a BINARY LARGE OBJECT (BLOB), server data type. This is a 8-bit per character string of up to 8 TB in length.

See Also:
Constant Field Values

LONGVARCHAR

public static final int LONGVARCHAR
A long CHARACTER VARYING data type. In Mimer SQL this corresponds to a CHARACTER LARGE OBJECT (CLOB), server data type. This is a 8-bit per character string of up to 8 TB in length.

See Also:
Constant Field Values

NULL

public static final int NULL
See Also:
Constant Field Values

NUMERIC

public static final int NUMERIC
The SQL datatype NUMERIC.

See Also:
Constant Field Values

OTHER

public static final int OTHER
See Also:
Constant Field Values

REAL

public static final int REAL
The SQL datatype REAL.

See Also:
Constant Field Values

SMALLINT

public static final int SMALLINT
The SQL datatype SMALLINT. This JDBC type code may also correspond to the Mimer specific datatype INTEGER(n), where n<5.

See Also:
Constant Field Values

TIME

public static final int TIME
The SQL datatype TIME.

See Also:
Constant Field Values

TIMESTAMP

public static final int TIMESTAMP
The SQL datatype TIMESTAMP.

See Also:
Constant Field Values

TINYINT

public static final int TINYINT
This constant identifies a SQL datatype TINYINT. Unfortunately, the SQL standard does not include such a datatype. In Mimer SQL this code corresponds to the ODBC.TINYINT system domain.

See Also:
Constant Field Values

VARBINARY

public static final int VARBINARY
The SQL standard does not support a BINARY data type. Mimer SQL implements a BINARY VARYING data type whose length is at most 15000 bytes.

See Also:
Constant Field Values

VARCHAR

public static final int VARCHAR
The SQL datatype CHARACTER VARYING. In Mimer SQL this corresponds to a 8-bit per character string of characters, with length specification, of up to 15000 characters.

See Also:
Constant Field Values

Mimer JDBC/MIDP 2.12

Submit a comment or suggestion Version 2.12 of Mimer JDBC for the CLDC/MID Profile Specification
Copyright Upright Database Technology AB, Box 1713, SE-751 47 UPPSALA, Sweden. All Rights Reserved.