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.