db.props

来自「torque服务器源代码」· PROPS 代码 · 共 42 行

# Taken from java.sql.Types in the IBM 1.3 JDK
# JDBC to DB2 mappings.

BIT =
TINYINT =
SMALLINT = SMALLINT
INTEGER = INTEGER
BIGINT = BIGINT
FLOAT = FLOAT
REAL = REAL
DOUBLE = DOUBLE
NUMERIC = NUMERIC
DECIMAL = DECIMAL
CHAR = VARCHAR
VARCHAR = VARCHAR
LONGVARCHAR = LONG VARCHAR
DATE = DATE
TIME = TIME
TIMESTAMP = TIMESTAMP
BINARY = CHAR(n) FOR BIT DATA 
# For DB2/400, VARBINARY must be changed to VARCHAR (32000) FOR BIT DATA
VARBINARY = VARCHAR(n) FOR BIT DATA 
LONGVARBINARY = LONG VARCHAR FOR BIT DATA
NULL = NULL
OTHER =
JAVA_OBJECT =
DISTINCT = DISTINCT
STRUCT =
ARRAY =
BLOB = BLOB
CLOB = CLOB
REF =

AUTOINCREMENT = GENERATED ALWAYS AS IDENTITY
NOTNULL = NOT NULL

removeNotNullWithAutoIncrement = true

suppressDefaults = false
maxColumnNameLength = 18