# JDBC to Oracle mappings.
#
# Good Oracle resources for determining these mappings include:
# http://technet.oracle.com/doc/oracle8i_816/java.816/a81354/basic3.htm
# http://technet.oracle.com/docs/tech/migration/workbench/doc_library/MSAccess/ch3.htm

BIT = NUMBER(1,0)
TINYINT = NUMBER(3,0)
SMALLINT = NUMBER(5,0)
INTEGER = NUMBER
BIGINT = NUMBER(20,0)
FLOAT = FLOAT
REAL = NUMBER
DOUBLE = FLOAT
NUMERIC = NUMBER
DECIMAL = NUMBER
CHAR = CHAR
VARCHAR = VARCHAR2
LONGVARCHAR = VARCHAR2
DATE = DATE
TIME = DATE
TIMESTAMP = DATE
BINARY = LONG RAW
VARBINARY = BLOB
LONGVARBINARY = LONG RAW
NULL =
OTHER =
JAVA_OBJECT =
DISTINCT =
STRUCT =
ARRAY =
BLOB = BLOB
CLOB = CLOB
REF =

NOTNULL = NOT NULL