Types (Mimer JDBC for the CLDC/MID Profile Specification)

Overview

Package

Class

Index

Help

Mimer JDBC/MIDP 2.12

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

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