derby支持的数据类型

 

JDBC Type Database Type Additional comments

ARRAY	BLOB	Will be read back as BLOB
BIGINT	BIGINT	$j\u001B<\u0001x_;(\u001E
BINARY	CHAR(n) FOR BIT DATA	\u001B/\u0007k{7b\u000BKf
BIT	SMALLINT	Cloudscape/Derby have no native boolean type 868cN[Ta\u000E   Will be read back as SMALLINT
BLOB	BLOB	R$\u000F0x\u001ES| J
BOOLEAN	SMALLINT	Cloudscape/Derby have no native boolean type I?kGngZ\u000CaC   Will be read back as BOOLEAN
CHAR	CHAR	@\u0005n:VY3U?R
CLOB	CLOB	'\u000C\u0006CdaF\u0006r1
DATALINK	LONG VARCHAR FOR BIT DATA	Will be read back as LONGVARBINARY
DATE	DATE	Wsc+A:\u0015<\u0007"
DECIMAL	DECIMAL	A/L\u0008Xta\u001F<F
DISTINCT	BLOB	Will be read back as BLOB
DOUBLE	Cloudscape: DOUBLE PRECISION Knz8\u0010(\u0015N.B   Derby: DOUBLE	e?. ]VA^C
FLOAT	Cloudscape: DOUBLE PRECISION \u000CN)g#H8Bh,   Derby: DOUBLE	Will be read back as DOUBLE
INTEGER	INTEGER	s?\u001D ?\u001ASYq9
JAVA_OBJECT	BLOB	Will be read back as BLOB
LONGVARBINARY	LONG VARCHAR FOR BIT DATA	\u000E;z8 K>C\u001E3
LONGVARCHAR	LONG VARCHAR	\u001EOufBZ4'00
NULL	LONG VARCHAR FOR BIT DATA	Will be read back as LONGVARBINARY
NUMERIC	NUMERIC	\u000F\u000FW^+ R69\u0008
OTHER	BLOB	Will be read back as BLOB
REAL	REAL	}d6\u0011-\u0017S<-0
REF	LONG VARCHAR FOR BIT DATA	Will be read back as LONGVARBINARY
SMALLINT	SMALLINT	l|(e\u0010}<E\u0017\u0017
STRUCT	BLOB	Will be read back as BLOB
TIME	TIME	?YS5\u001BP%:3f
TIMES*****P	TIMES*****P	-\u00046r|\u001D \u001Bk\u001D
TINYINT	SMALLINT	Will be read back as SMALLINT
VARBINARY	VARCHAR(n) FOR BIT DATA	DYl\u0005f :\u0014PD
VARCHAR	VARCHAR

 

derby不支持boolean,

来源http://db.apache.org/ddlutils/databases/derby.html