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
number	NUMERIC	NUMERIC	NUMBER
float	FLOAT (< 6 dec. positions) DOUBLE (>= 6 dec. positions)	REAL (< 6 dec. positions) DOUBLE (>= 6 dec. positions)	NUMBER
char	VARCHAR	VARCHAR	VARCHAR2
text	BIGTEXT MEDIUMTEXT TEXT	TEXT	CLOB
binary	BIGBLOB MEDIUMBLOB BLOB	BYTEA	BLOB
date with time	DATETIME	TIMESTAMP	DATE

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