XMLDB column types

XML database schema > XMLDB column types

---

This page will show, once finished, one compatibility matrix of column types for each of the RDBMS under which Moodle is expected to work.

The matrix

XMLDB Type	MySQL	PostgreSQL	Oracle	MSSQL
int	BIGINT (>9 digits) INT (>6 digits) MEDIUMINT (>4 digits) SMALLINT (>2 digits) TINYINT (<=2 digits)	BIGINT (>9 digits) INTEGER (>4 digits) SMALLINT (<=4 digits)	NUMBER	BIGINT (>9 digits) INTEGER (>4 digits) SMALLINT (<=4 digits)
number	NUMERIC	NUMERIC	NUMBER	DECIMAL
float	FLOAT (< 6 dec. positions) DOUBLE (>= 6 dec. positions)	REAL (< 6 dec. positions) DOUBLE PRECISION (>= 6 dec. positions)	NUMBER	REAL (< 6 dec. positions) FLOAT (>= 6 dec. positions)
char	VARCHAR	VARCHAR	VARCHAR2	NVARCHAR
text	LONGTEXT MEDIUMTEXT TEXT	TEXT	CLOB	NTEXT
binary	LONGBLOB MEDIUMBLOB BLOB	BYTEA	BLOB	IMAGE
date with time	DATETIME	TIMESTAMP	DATE	DATETIME

Some official links

• MySQL: http://dev.mysql.com/doc/refman/5.0/en/data-types.html
• PostgreSQL: http://www.postgresql.org/docs/7.4/static/datatype.html
• SQL*Server: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7msw.asp
• Oracle: http://www.cs.umbc.edu/help/oracle8/server.815/a68003/01_04blt.htm