symfony里面定义数据类型

Type	MySQL Type	pgSQL Type
integer	integer	int/serial
integer(1)	tinyint	smallint/serial
integer(2)	smallint	smallint/serial
integer(3)	mediumint	int/serial
integer(4)	int	int/serial
integer(5)	bigint	bigint/bigserial
float	double	float
double	double	float
decimal	decimal	numeric
char	char	char
varchar	varchar	varchar
string	varchar	varchar
array	text	text
object	text	text
blob	longblob	bytea
blob(255)	tinyblob	bytea
blob(65532)	blob	bytea
blob(16777215)	mediuumblob	bytea
clob	longtext	text
clob(255)	tinytext	text
clob(65532)	text	text
clob(16777215)	mediumtext	text
timestamp	datetime	timestamp without timezone
time	time	time without timezone
date	date	date
gzip	text	text
boolean	tinyint(1)	boolean
bit	bit	varbit
varbit	n/a	varbit
inet	n/a	inet
enum	-see below-	-see below-

转载于:https://blog.51cto.com/leexiaobo/1008237