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)
number	:NUMERIC
float	FLOAT (< 6 dec. positions) DOUBLE (>= 6 dec. positions)
char	VARCHAR
text	BIGTEXT MEDIUMTEXT TEXT
binary	BIGBLOB MEDIUMBLOB BLOB
date with time	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