dbal表类型 - Wiki管理

[TOC]

DBAL类型

下表是dbal类型与mysqll类型的对应表, 其中required和comment属性是所有dbal类型天生具备的.

doctrine类型	默认mysql类型	length	precision	scale	autoincrement	unsigned	fixed
array	text	√	×	×	×	×	×
array_simple	text	×	×	×	×	×	×
json_array	text	×	×	×	×	×	×
bigint	bigint	×	×	×	√	√	×
boolean	tinyint(1)	×	×	×	×	×	×
datetime	datetime	×	×	×	×	×	×
datetimez	datetime	×	×	×	×	×	×
date	date	×	×	×	×	×	×
time	time	×	×	×	×	×	×
decimal	numeric(10,0)	×	√	√	×	×	×
integer	int	×	×	×	√	√	×
object	text	×	×	×	×	×	×
smallint	smallint	×	×	×	√	√	×
string	varchar(255)	√	×	×	×	×	√
text	longtext	×	×	×	×	×	×
binary	varbinary(255)	√	×	×	×	×	√
blob	longblob	×	×	×	×	×	×
float	double precision	×	×	×	×	×	×
guid	char(36)	×	×	×	×	×	×
text	longtext	×	×	×	×	×	×